Running Total

[open a adobe file from a command button]

I have a spreadsheet that has 2 columns, column A grows, column B shrinks,
when column B gets to 0 or a negative number I want column A to be blank.

Thank You Very Much

 

[Fred Smith]

Use something like:
=if(b1<=0,"",<yourformula>)

Regards,
Fred.

"open a adobe file from a command button"

 

[open a adobe file from a command button]

Fred, Hi. Thanks that works great! What if I wanted 2 or more cells to be
blank if F5<= 0?

Thanks Again!!

 

[JBeaucaire]

The answer is exactly the same. For every cell that you want to blank out
based on the value in F5, put the formula:

=IF(F5<=0,"",<yourformula>)

 

[open a adobe file from a command button]

Thanks, but I don't understand; my formula is =if(f1<0,"",employee*I66), but
now I want if(f1<0 G1,H1, & I1 are blank, how would that fit in or do I have
to nest if statements?

 

[Fred Smith]

You use either the And or Or function, depending on whether you're checking
for all to be blank, or any one. For example:

=if(and(f1<=0,g1<=0,H1<=0,I1<=0),"",<yourformula>)
=if(or(f1<=0,g1<=0,H1<=0,I1<=0),"",<yourformula>)

Regards,
Fred.

"open a adobe file from a command button"

 

[open a adobe file from a command button]

I see said the blind man!! Thank you very much

You use either the And or Or function, depending on whether you're checking
for all to be blank, or any one. For example:

=if(and(f1<=0,g1<=0,H1<=0,I1<=0),"",<yourformula>)
=if(or(f1<=0,g1<=0,H1<=0,I1<=0),"",<yourformula>)

Regards,
Fred.

"open a adobe file from a command button"

 

[Fred Smith]

Glad I could help. Thanks for the feedback.

Regards,
Fred.

"open a adobe file from a command button"