I am attempting to create a IF function that will give me 4 possible results.
Between 1000 and 524, 0 and 224 should result in "R"
Between 525 and 501, 225 and 249 should result in "LS"
Between 500 and 438, 250 and 312 Should Result in "FT"
Between 313 and 436 should result in "A"
This was my first hasty attempt
=IF(AND(F13<0,F13<225),IF(AND(F13>224,F13<250),IF(AND(F13>249,F13<313),IF(AND(F13>312,F13<438),IF(AND(F13>437,F13.501),IF(AND(F13>500,F13<526),IF(AND(F13>525),"R"),"L/S"),"F/T"),"A"),"F/T"),"L/S"),"R")
and the start of my Second
=IF(F13>1000,IF(F13<526,"R"))
the second one works until I add more fields.
Bookmarks