#### moderated Help with Excel problem

Onwardbob

Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

Chris Chaffin

If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:

﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

Marty Hutchings

Chris,  What if the rest of my formula is another IF statement?

On 1/5/2022 10:52 PM, Chris Chaffin wrote:
If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:

﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

--
Thanks,
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison
(262) 605-8981
mhutchings152730@gmail.com
www.wisconsinbold.com

Chris Chaffin

That is not a problem. You can have multiple if statements within a single formula. If you want to send me a copy of your formula, I will show you.

Chris

On Jan 6, 2022, at 12:11 AM, Marty Hutchings <mhutchings152730@gmail.com> wrote:

﻿Chris, What if the rest of my formula is another IF statement?

On 1/5/2022 10:52 PM, Chris Chaffin wrote:
If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:
﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

--
Thanks,
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison
(262) 605-8981
mhutchings152730@gmail.com
www.wisconsinbold.com

Marty Hutchings

Chris,  Here is my formula.  =IF(B3=C3,B3+1,"0")  It is for figuring a player's score in a card game, but it returns a 1 in the cell when there should be nothing, because the two cells being compared have nothing in them.  I want the formula cell to also show blank until something is added to the cells to the left.

Thanks.

Marty

On 1/6/2022 7:00 AM, Chris Chaffin wrote:
That is not a problem. You can have multiple if statements within a single formula. If you want to send me a copy of your formula, I will show you.

Chris

On Jan 6, 2022, at 12:11 AM, Marty Hutchings <mhutchings152730@gmail.com> wrote:

﻿Chris, What if the rest of my formula is another IF statement?

On 1/5/2022 10:52 PM, Chris Chaffin wrote:
If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:
﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

--
Thanks,
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison
(262) 605-8981
mhutchings152730@gmail.com
www.wisconsinbold.com

--
Thanks,
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison
(262) 605-8981
mhutchings152730@gmail.com
www.wisconsinbold.com

Onwardbob

Hi, the formula I was using is, if(b3=0,0,f2-e3+d( that left me with all the zeros. I'll give yours a try...thanks

BOB SOUTAR…ONWARD THRU THE FOG

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Chris Chaffin
Sent: Wednesday, January 05, 2022 8:53 PM
To: main@jfw.groups.io
Subject: Re: Help with Excel problem

If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:

﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

Onwardbob

OK Chris I tried with =if(b3=0,0,f2-e3+d3) and I still have zeros down to a million something. Could the problem that I'm using Excell-10?

BOB SOUTAR…ONWARD THRU THE FOG

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Chris Chaffin
Sent: Wednesday, January 05, 2022 8:53 PM
To: main@jfw.groups.io
Subject: Re: Help with Excel problem

If you are referring to zeros populating rows that you have not yet entered a transaction for, I am not sure of your original formula, but I just use an if statement to leave the cell blank unless that row has information in it.

Something like this:

If(a3="","", ... rest of your formula... then make sure to end it with a )
The A3 is just the first cell of the row you are doing. You can use any cell that you will enter information in for each row.

If you have more questions feel free to let me know.

Chris

On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@roadrunner.com> wrote:

﻿Hi, using Excel-10, J-22, w-10 and setting up a check register with a
running balance. OK, so how do I stop the millions of zeros from populating
below my running balance? I last did it back with W-7, and don't know how
and sure not with w-10. thanks...

BOB SOUTAR.ONWARD THRU THE FOG

Chris Chaffin

Hi Marty,

This formula says if cell b3 is blank, then make this cell blank also. But if b3 is not blank, then do your if statement.

=IF(b3="","",IF(B3=C3,B3+1,"0"))

Hope this helps. Let me know if you have questions.

Chris

On Jan 6, 2022, at 8:55 AM, Marty Hutchings <mhutchings152730@gmail.com> wrote:

=IF(B3=C3,B3+1,"0")

Marty Hutchings

Chris,  That is very slick.  Thanks.

On 1/6/2022 7:14 PM, Chris Chaffin wrote:
Hi Marty,

This formula says if cell b3 is blank, then make this cell blank also. But if b3 is not blank, then do your if statement.

=IF(b3="","",IF(B3=C3,B3+1,"0"))

Hope this helps. Let me know if you have questions.

Chris

On Jan 6, 2022, at 8:55 AM, Marty Hutchings <mhutchings152730@gmail.com> wrote:

=IF(B3=C3,B3+1,"0")

--
Thanks,
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison
(262) 605-8981
mhutchings152730@gmail.com
www.wisconsinbold.com

 1 - 9 of 9