The IF function but with 3 values
Assuming the OP wanted numbers rather than text, the 3.5 should not be
in quotes. If the OP wanted text instead, the other values should be in
quotes.
In article ,
Mike wrote:
=IF(I7<2,"3.5",IF(I7=2,3.2,IF(I7=3,2.8)))
The above will give the answer you want but are you sure your logic is
correct. What happens between 2 and 3?
|