| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=IF(A1<=600,A1*0.06,36+(A1-600)*0.08)
-- Vasant "Dave Smith" <Dave wrote in message ... I'm trying to calculate an electricity bill which uses different values based on the amount used. For the first 600 kwh, the charge is .06/kwh. For anything above 600 kwh, the charge is .08/kwh. So if my usage is 700 kwh, my bill is $36+$8. Any ideas on which formula I should use for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) | |||
Threaded Mode
