eliminating negative numbers in a cell

[andrewb90]

Hello,

I have a daily worksheet where the grand total sales will carry from day to day. (cell B3) in cell B2 I put in the new grand total amount that I got from my register report. With that put in, B6 calculates the total sales for the day (B2-B3). My problem with this, is that until a number is placed in B2, the sales total is in the negative, and makes looking at the week to date numbers impossible until the entire week has been completed.

Is there some way to have that total not calculate until an amount is typed into cell B2?

Thanks,

Andrew

 

[T. Valko]

Hello,

I have a daily worksheet where the grand total sales will carry from day to day. (cell B3) in cell B2 I put in the new grand total amount that I got from my register report. With that put in, B6 calculates the total sales for the day (B2-B3). My problem with this, is that until a number is placed in B2, the sales total is in the negative, and makes looking at the week to date numbers impossible until the entire week has been completed.

Is there some way to have that total not calculate until an amount is typed into cell B2?

Thanks,

Andrew

Like this...

=IF(COUNT(B2),B3-B2,"")

 

[S.H.A.D.O.]

Hi Andrew,

You could try putting at the very beginning of the formula something like:-

=IF(B2=0,"", YOUR FORMULA...

I hope this helps!

 

[andrewb90]

Wow! That was far simpler than I would have imagined. Thanks!

 

[T. Valko]

Wow! That was far simpler than I would have imagined. Thanks!

You're welcome. Thanks for the feedback!

 

[S.H.A.D.O.]

You're welcome.
Thanks for the feedback!