Results 1 to 6 of 6

Help with nested IF formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    6

    Help with nested IF formula

    First post on here. I tried to look for help on IF AND but I think my specific formula was to complicated for me.


    I need help with cell Z15.

    My formula is:
    IF(F14=1,100, IF(F14=2,50, IF(F14>=5, IF(AND(W3>=3499.99,(I15+J15+K15+L15+O15+P15+Q15+R15+S15+T15+U15+V15+W15+X15)*-0.5,0))))

    Im trying to say if W3 is>3999.99 then to do the (I15+J15+K15+L15+O15+P15+Q15+R15+S15+T15+U15+V15+W15+X15)*-0.5,0), but if its not then to output 0,

    so if F14=1 (outputs 100) or 2 (out puts 50). If F14 = 5 then to take that row x 50%. only if W3 is above 3499.99 though, if its below 3499.99 then i want it to output 0


    Thanks for your help and time to look at this.
    Last edited by xx8josh9xx; 07-01-2013 at 02:07 AM. Reason: changed thread title to OP

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1