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.
toggle quoted messageShow quoted text
On Jan 6, 2022, at 12:11 AM, Marty Hutchings <mhutchings152730@...> 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.
On Jan 5, 2022, at 11:29 PM, Onwardbob <onwardbob@...> 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
Lion Marty Hutchings
BOLD Secretary, Program Director and VIP Liaison