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

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