Nested And/IF Statments
Solved/Closed
nelsojm
nelsojm
- Posts
- 2
- Registration date
- Friday November 1, 2013
- Status
- Member
- Last seen
- November 4, 2013
nelsojm
- Posts
- 2
- Registration date
- Friday November 1, 2013
- Status
- Member
- Last seen
- November 4, 2013
Related:
- Nested And/IF Statments
- How many if statements can you nest in excel - Guide
- Which of the following nested if functions are correct ✓ - Forum - Office Software
- Nest's Security Cam Recognizes Intruders - News
- Nest Hub Max Takes On Amazon Echo Show - CCM - News
- Nested if then ✓ - Forum - Excel
2 replies
Kevin@Radstock
Nov 2, 2013 at 10:01 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
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
Nov 1, 2013 at 08:19 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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