| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If statement help
Hi,
I believe this would be categorized as a "nested if" question. I have to calculate different pricing based on weight categories. So- in English, it would be: If cell a1 is greater than 1000 but less than 1999 then multiply a1 times c4, if A1 is greater is greater than 1999 but less than 2999 then multiply A1 times C5, etc Can someone provide an example of that syntax?? Thanks so much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
![Edward[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
