Using "IF" function for formating

[Chris W]

I have done this once before and cant figure it out now.

I am trying to have a group of cells show up as blank
instead of #DIV/0! if a portion of the formula is null.
I have 4 colums that caculate price based on a quantity.
If no quantity is listed for that colum, I want the
result cells blank.

 

[Frank Kabel]

Hi
try something like
=IF(OR(C1=0,C1=""),"",A1/C1)

 

[Peo Sjoblom]

=IF(divisor=0,"",your_formula)

 

[Trevor Shuttleworth]

Chris

One way:

=IF(ISERROR(your formula),"",your formula)

More specifically:

=IF(B1=0,"",A1/B1)

You need to check the divisor for being 0 ... if you divide by zero, you get
#DIV/0!

Regards

Trevor

 

[Chris W]

Thanks, that worked.

-----Original Message-----
Hi
try something like
=IF(OR(C1=0,C1=""),"",A1/C1)

--
Regards
Frank Kabel
Frankfurt, Germany


.