I need to test a cell for a value:
If the cell is <= 150 then return SR250
If the cell is 150> but <350 then return SR475
If the cell is <350 then return 25X3
I've created a formula but only the 1st two steps are working, if the cell value is 351 it still only returns "SR475" what am I doing wrong?
=IF(D8<=150,"SR250",IF(350<D8>150,"SR475",IF(350>D8,"25x3")))
Bookmarks