Forum Discussion
nested if statement
I wrote the below nested if formula, but I'm getting no results. Could someone please take a look at it and tell me what I've done wrong or what's missing? '= if(O2<19,239,"A",if(O2>19,240,...
SergeiBaklan - No, that changed the formula completely. The results I require must come from the greater than number.
Thank you,
And alternatively you may use formula like
=LOOKUP(O2,
{-1000,19239,24440,30680,39000,49920,62920,80080,101920,128960,163800,208000},
{"A","B","C","D","E","F","G","H","I","J","K","L"}
)Of course, it's better not to hardcode constants but put in some ranges.
I reversed the numbers and the below actually worked except for the "1" position. Not sure why it's not returning that information,
= IF(O9>208000, "12",IF(O9>163800, "11",IF(O9>128960, "10",IF(O9>101920, "9",IF(O9>80080, "8",IF(O9>62920, "7",IF(O9>49920, "6",IF(O9>39000, "5",IF(O9>30680, "4",IF(O9> 24440, "3",IF(O9>19240, "2",”1”)))))))))))
- i figured it out, I needed to remove the paren's around the 1.