# Nested IF/then statements

0

I can do basic formulas in excel. I am in the process of building a spreadsheet to help track our maintenance due on our equipment.

this is the formula I have

=IF((H17-I17)>="200","pm1","0")=IF((H17-I17)>="450","pm2","0")=IF((H17-I17)>="950","pm3","0")=IF((H17-I17)>"1950","pm4","0")

when i hit enter it comes back as false. Am not sure what I did wrong.

Any help with this would be greatly appreciated

Thank you

Wanda

0

You havent actually nested the IF functions.

Im on mobile now so i cant test one for you but here is our tutorial on nesting if functions. Check that out and it should explain everything.

### Update

(back on my computer now)

Your formula is not nested correctly but also will fail to return the correct numbers since you don't check if the number is within a range. You check if it is greater than 200 and then greater than 450 etc, but if the number is 2000, it will return true for every IF statement that is checked against it. As such, I added some AND functions to check for a range and nested the IF statements.

``=IF(AND((H17-I17)>="200",(H17-I17)<450),"pm1",IF(AND((H17-I17)>="450",(H17-I17)<950),"pm2",IF(AND((H17-I17)>="950",(H17-I17)<1950),"pm3",IF((H17-I17)>"1950","pm4","0"))))``

In reality though, you should be using a VLOOKUP function for a range of numbers for this.

### Discussion

The numbers being between double quotes are text...
pecoflyer Jan 8, '17 at 8:10 am
I just took the formula that they provided and went with it since that seemed to be the least of the issues to begin with.
don (rep: 1521) Jan 10, '17 at 12:24 pm
Thank you for the help I know see what I needed to do.
wanda (rep: 2) Jan 11, '17 at 4:17 pm