daniel_e
Reputation: 257
Nested IF statements with 3 conditions in excel
I have three conditions in ONE cell:
- IF A1 is smaller than 22000 write 3.600.
- IF A1 is bigger than 64000 write 9600.
- IF A1 is in between 22000 AND 64000 calculate A1+B2
I don't really get it working…
This is what I have for now: IF(OR(A1>64000;A1<22000);(A1+B1);IF(A1>64000;9600;))
Somehow the (A1<22000;3600;) is missing and won't fit anywhere... Totally lost.
Can someone help?
Upvotes: 1
Views: 44
Answers (1)
Related Questions
- Nested IF statements on Excel
- If-else statement with multiple conditions in microsoft excel
- Nested If statement 3 conditions and 1 definitive
- using Nested IF statement in excel
- working with Nested IF statement in excel
- Nested IF formulas
- using multiple IF statement with 3 conditions
- Excel: Nested IF statement to check 3 conditions
- Nesting multiple IF AND statement conditionals
- Nested IF Statements in Excel Formula