Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi how would I write a formula to calculate the following
cell b2 contains 0.02169 cell B3 contains 0.01590 cell D2 contains 5860 and column G contains numbers from 1 to 20845 Units Rate 1 0.02169 (first 5,860 units) 5860 £127.10 Units Rate 2 0.01590 20845 14985 £238.26 Total £365.36 It is to calculate my gas bill where the first 5860 units cost .02169 and the rest cost .01590 I can work it out manually but how do I write a formula that will calculate it in excell? Thanks Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Creating a check mark box | Setting up and Configuration of Excel |