I
IF function incompetent
I am trying to do a similar thing but my values are different.
Can someone help me with this one??
Can someone help me with this one??
R
Ron Rosenfeld
I am trying to do a similar thing but my values are different.
Can someone help me with this one??
IT will be easier to use VLOOKUP. Then you can set your values/equivalences to
whatever you want.
--ron
M
Mike H
possibly
=IF(J16<0,"",CHOOSE(MIN(J16+1,6),0,1.5,1.7,2,2.5,""))
Mike
=IF(J16<0,"",CHOOSE(MIN(J16+1,6),0,1.5,1.7,2,2.5,""))
Mike