Thanks:  0
Likes:  0

1. 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?

2. 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 ]

3. 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&""""))

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•