Remember Me?

#1
June 21st 06, 03:41 AM posted to microsoft.public.excel.misc
 Josh Davis Posts: n/a
Subtract Range Of Numbers using a Formula

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.

Josh

#2
June 21st 06, 04:05 AM posted to microsoft.public.excel.misc
 Max Posts: n/a
Subtract Range Of Numbers using a Formula

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.

Josh

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM tim Excel Worksheet Functions 2 January 12th 05 09:10 PM

All times are GMT +1. The time now is 01:18 PM.