formule help....
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: formule help....

  1. #1
    Guest

    Default

     
    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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com