Related:
- If statements...causing trouble!
- Trouble signing into yahoo mail - Guide
- How many if statements can you nest - Guide
- Excel if statement with text - Guide
- Excel if statements with dates - Guide
- If statement alteryx - Programming Forum
1 response
=IF(e7=0,"",IF(e7=<3,e7*100,IF(e7=<6,e7*200,IF(e7=<10,e7*300,IF(e7=>10,"","")))))
What is happening here is,
If e7 is zero then blank, if it's less than 3 then *100, less than 6 then *200, less than 10 then *300, more than 10 then blank.
You may need to play with it, like if this doesn't work right then use >11 at the end instead of 10 but excel should be alright with overriding the previous "IF" when the next one is a better match.
If this works, you will be my first "answered" - I look foreward to that moment since this site has answered so many of my excel issues
What is happening here is,
If e7 is zero then blank, if it's less than 3 then *100, less than 6 then *200, less than 10 then *300, more than 10 then blank.
You may need to play with it, like if this doesn't work right then use >11 at the end instead of 10 but excel should be alright with overriding the previous "IF" when the next one is a better match.
If this works, you will be my first "answered" - I look foreward to that moment since this site has answered so many of my excel issues
