If value between 2 numbers
On Mon, 10 Dec 2012 16:03:37 +0000, CMoHorn wrote:
I am working on an inventory spreadsheet. The formula I need help with
is IF("VLOOKUP VALUE") is between 1-19 then "LOW"; IF "VALUE" between
20-49 then "MEDIUM"; IF "VALUE" between 50-74 then "HIGH"; IF "VALUE" =
75 then "HEAVY".
I hope that makes sense. Thanks.
And here is another that assumes VALUE will always be an integer, and that you have not defined what you want returned if VALUE is not a number =1:
=IF(OR(A1<1,NOT(ISNUMBER(A1))),"undefined",IF(A1<2 0,"LOW",IF(A1<50,"MEDIUM",IF(A1<75,"HIGH","HEAVY") )))
|