Running Total

  • Thread starter Thread starter open a adobe file from a command button
  • Start date Start date
O

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
 
Use something like:
=if(b1<=0,"",<yourformula>)

Regards,
Fred.

"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!!
 
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>)
 
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?
 
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"
 
I see said the blind man!! Thank you very much

Fred Smith said:
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"
Click to expand...
 
Glad I could help. Thanks for the feedback.

Regards,
Fred.

"open a adobe file from a command button"
 
Back
Top