Related:
- If statements...causing trouble!
- How many if statements can you nest - Guide
- If then statements in excel - Guide
- Onlyfans statements - Guide
- We are having trouble previewing this file yahoo - Guide
- Yahoo trouble signing in - Guide
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