formule help....

[Guest]

I need some help with this formula...

=IF(D32=0," ",IF(D32>0, D32 &" x "&ROUND(D36/D31+2,0)&" #"&D30&" x "&D28&""""))

Basically, if D32 is either 0 or null, I need it to show null, but if D32 has a value of 1 or more, then use that value in the second if statement. Any advice?

 

[Mark W.]

On 2002-02-26 14:11, Anonymous wrote:
I need some help with this formula...

=IF(D32=0," ",IF(D32>0, D32 &" x "&ROUND(D36/D31+2,0)&" #"&D30&" x "&D28&""""))

Basically, if D32 is either 0 or null, I need it to show null, but if D32 has a value of 1 or more, then use that value in the second if statement. Any advice?

Excel doesn't have a NULL value. If by NULL you mean a null string (a text string of 0 length) use...

=IF(D32>0,D32&" x "&ROUND(D36/D31+2,0)&" #"&D30&" x "&D28&"""","")
This message was edited by Mark W. on 2002-02-26 14:23

 

[Mudface]

If D31 has a value in it then the following might do you, but I'm not sure about the rest of your formula, what is it you're trying to do exactly?

=IF(OR(D32="",D32=0),"",IF(OR(D32<>"",D32<>0), D32 &" x "&ROUND(D36/D31+2,0)&" #"&D30&" x "&D28&""""))