IF/OR Formula Solved/Closed

Question

Help please
I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0
for example
A    B               C
A1 Number return required
A2    1                 1
A3    7            0
A4    3             0.4
A5    5            0
A6    2            0.6
A7    4                 0.2
A8    6            0

Thanks in advance

vcoolio · Answer

Hello ad1959,

Perhaps a nested IF formula is all you need:-

=IF(A2=1,1,IF(A2=2,0.6,IF(A2=3,0.4,IF(A2=4,0.2,IF(A2>4,0.0,"")))))

Place it in cell B2 and drag it down as far as you like.

Cheerio,
vcoolio.

ad1959 · Answer

Thanks vcoolio exactly what i was after.

IF/OR Formula

2 responses

Similar discussions

Subscribe To Our Newsletter!