Related:
- If statements...causing trouble!
- How many if statements can you nest in excel - Guide
- Trouble with netflix - Guide
- Trouble signing into yahoo email - Guide
- Excel if statements with dates - Guide
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - 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
