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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 10, 2015 at 04:25 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 10, 2015 at 04:25 AM
Related:
- IF/OR Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
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
Feb 10, 2015 at 04:09 AM
Thanks vcoolio exactly what i was after.
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Feb 9, 2015 at 06:03 AM
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.
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.
Feb 10, 2015 at 04:25 AM
Cheerio,
vcoolio.