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"
osoft.com wrote in
message ...
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?

"JBeaucaire" wrote:

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)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"open a adobe file from a command button" wrote:

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

Thanks Again!!

"Fred Smith" wrote:

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

Regards,
Fred.

"open a adobe file from a command button"
osoft.com wrote in
message ...
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