IF/OR Formula

Solved/Closed
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Feb 9, 2015 at 05:06 AM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Feb 10, 2015 at 04:25 AM
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

2 responses

ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 1
Feb 10, 2015 at 04:09 AM
Thanks vcoolio exactly what i was after.
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Feb 10, 2015 at 04:25 AM
You're welcome. Glad I could help.

Cheerio,
vcoolio.
0
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Feb 9, 2015 at 06:03 AM
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.