Related:
- If statements...causing trouble!
- How many nested if statements in excel - Guide
- If then statements in excel - Guide
- Trouble logging into yahoo mail - Guide
- Onlyfans statements - Guide
- Remove false from if statement ✓ - Excel 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