Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
Hi, I am fairly new at excel and first time using this chat room. I am using
excel 2003 and trying to come up with a formula that will do the following. Cell A1 = 166570 gallons I want excel to calculate 0 €“ 3000 gallons Base Charge $11.52 3000 but <13000 * 0.00087 <13000 * 0.00072 So when I enter 166570 in cell A1 it automatically calculates $130.79 in cell C1 or lets say just $11.52 in cell C1 if <3000 gallons used or $20.22 in cell C1 if 10000 gallons were used. Any help would be appreciated. -- Thanks for your time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
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 |