Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    nested if formula? (2000)

    Hi
    Here is my formula in H2 =if(F2-E2>0,(F2-E2),"") Which works great but now they also would like the formula to also say NA if F2-E2 is greater then 100. Would this be some kind of nexted if formula?
    Thanks for any help

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: nested if formula? (2000)

    How about:
    =if(F2-E2>100,na(),if(F2-E2>0,(F2-E2),""))

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: nested if formula? (2000)

    Steves function returns #N/A if F2-E2>100. If you rather want a text entry of N/A, then replace NA() with "N/A".
    Regards,
    Rudi

Posting Permissions

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