C
Carolina Girl
Please help… I have 3 cells with formulas in them
Cell L4
=IF(I4="< 5","4",IF(I4="5 - 199","3",IF(I4="200 - 500","2",IF(I4=">
500","1"," "))))
Cell M4
=IF(J4="< 500","4",IF(J4="500 - 19,999","3",IF(J4="20k - 50k","2",IF(J4=">
50k","1"," "))))
Cell N4
=IF(K4="< 5","4",IF(K4="5 - 199","3",IF(K4="200 - 500","2",IF(K4=">
500","1"," "))))
I need to be able to pull the smallest number that these calls fill in. I
tried to use the Min formula but I think Excel only sees the 4, 3, 2&1 in my
formula as text and not numbers. I tried formatting but that did not work
ether. Can anyone give me a suggestion on haw to fix this????
Cell L4
=IF(I4="< 5","4",IF(I4="5 - 199","3",IF(I4="200 - 500","2",IF(I4=">
500","1"," "))))
Cell M4
=IF(J4="< 500","4",IF(J4="500 - 19,999","3",IF(J4="20k - 50k","2",IF(J4=">
50k","1"," "))))
Cell N4
=IF(K4="< 5","4",IF(K4="5 - 199","3",IF(K4="200 - 500","2",IF(K4=">
500","1"," "))))
I need to be able to pull the smallest number that these calls fill in. I
tried to use the Min formula but I think Excel only sees the 4, 3, 2&1 in my
formula as text and not numbers. I tried formatting but that did not work
ether. Can anyone give me a suggestion on haw to fix this????