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