Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I was wanting to take a standard currency form cell containing the following number: "$180.00" in cell "F4" and be able to subtract that from the nubers formatted in the currency form in cells "F5:F10" so that the difference in these numbers is displayed in cell "F12". If you do not understand this let me put this in a mathmatical sense. I want to take the $180.00, subtract 32.09-16.27-16.27-19.48-15.35-44.69. those ammount are cells "F5:F10" I would like the difference of those totals displayed in cell "F12" as previously stated. So can anyone help me? your help would be greatly appreciated. Thanks In Advance, Josh |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Perhaps ... in F12: =F4-SUM(F5:F10)
would do it here ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Josh Davis" wrote: Hello, I was wanting to take a standard currency form cell containing the following number: "$180.00" in cell "F4" and be able to subtract that from the nubers formatted in the currency form in cells "F5:F10" so that the difference in these numbers is displayed in cell "F12". If you do not understand this let me put this in a mathmatical sense. I want to take the $180.00, subtract 32.09-16.27-16.27-19.48-15.35-44.69. those ammount are cells "F5:F10" I would like the difference of those totals displayed in cell "F12" as previously stated. So can anyone help me? your help would be greatly appreciated. Thanks In Advance, Josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |