main@jfw.groups.io | Help with Excel problem

Home Messages Hashtags Subgroups

Date Date 1 - 9 of 9

Help with Excel problem

Onwardbob #94920 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
More All Messages By This Member
Chris Chaffin #94921 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 toggle quoted messageShow quoted text 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
More All Messages By This Member
Marty Hutchings #94922 Chris, What if the rest of my formula is another IF statement? toggle quoted messageShow quoted text 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
More All Messages By This Member
Chris Chaffin #94932 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 toggle quoted messageShow quoted text 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
More All Messages By This Member
Marty Hutchings #94933 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. Please show me what it would look like with your formula added. Thanks. Marty toggle quoted messageShow quoted text 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
More All Messages By This Member
Onwardbob #94937 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 toggle quoted messageShow quoted text -----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
More All Messages By This Member
Onwardbob #94941 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 toggle quoted messageShow quoted text -----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
More All Messages By This Member
Chris Chaffin #94942 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 toggle quoted messageShow quoted text On Jan 6, 2022, at 8:55 AM, Marty Hutchings <mhutchings152730@gmail.com> wrote: =IF(B3=C3,B3+1,"0")
More All Messages By This Member
Marty Hutchings #94943 Chris, That is very slick. Thanks. toggle quoted messageShow quoted text 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
More All Messages By This Member

1 - 9 of 9

1

Previous Topic Next Topic

Home Hashtags Subgroups About Features Pricing Updates Terms Help Twitter