moderated Re: Help with Excel problem
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...thankstoggle quoted messageShow quoted text
BOB SOUTAR…ONWARD THRU THE FOG
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf Of Chris Chaffin
Sent: Wednesday, January 05, 2022 8:53 PM
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.
On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@...> wrote: