Nested And/IF Statments
Solved/Closed
nelsojm
Posts
2
Registration date
Friday November 1, 2013
Status
Member
Last seen
November 4, 2013
-
Nov 1, 2013 at 04:23 PM
nelsojm Posts 2 Registration date Friday November 1, 2013 Status Member Last seen November 4, 2013 - Nov 4, 2013 at 01:49 PM
nelsojm Posts 2 Registration date Friday November 1, 2013 Status Member Last seen November 4, 2013 - Nov 4, 2013 at 01:49 PM
Related:
- Nested And/IF Statments
- How many nested if statements in excel - Guide
2 responses
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Nov 2, 2013 at 10:01 AM
Nov 2, 2013 at 10:01 AM
Hi nelsojm
Try the following LOOKUP function.
=LOOKUP(A1,{0,5,10},{10,15,22})
Or another alternative is the VLOOKUP.
https://www.contextures.com/excelvlookupexamples.html
Try the following LOOKUP function.
=LOOKUP(A1,{0,5,10},{10,15,22})
Or another alternative is the VLOOKUP.
https://www.contextures.com/excelvlookupexamples.html
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 1, 2013 at 08:19 PM
Nov 1, 2013 at 08:19 PM
try this
=IF(a1="","", if(a1>=10,22,if(a1>=5,15, if(a1>=1,10,0))))
=IF(a1="","", if(a1>=10,22,if(a1>=5,15, if(a1>=1,10,0))))
Nov 4, 2013 at 01:49 PM