addition, subtraction in a single cell formula

's Computer Specifications

I need help updating a single cell formula.

G4 has a formula of *=12500-A7

I would like to update this so that A7, A8, A9 are added together then
subtracted from 12500.

Any help would be greatly appreciated.

mePenny

's Computer Specifications

=12500-SUM(A7:A9)
OR
=12500 - A7 - A8 - A9
OR
12500 - (A7 + A8 + A9)
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"mePenny" <(E-Mail Removed)> wrote in message
news:47A0D90D-164B-4821-9315-(E-Mail Removed)...
> I need help updating a single cell formula.
>
> G4 has a formula of *=12500-A7
>
> I would like to update this so that A7, A8, A9 are added together then
> subtracted from 12500.
>
> Any help would be greatly appreciated.
>
> mePenny

's Computer Specifications

Try

=12500-SUM(A7:A9)

If this post helps click Yes
---------------
Jacob Skaria

"mePenny" wrote:

> I need help updating a single cell formula.
>
> G4 has a formula of *=12500-A7
>
> I would like to update this so that A7, A8, A9 are added together then
> subtracted from 12500.
>
> Any help would be greatly appreciated.
>
> mePenny

's Computer Specifications

Jacob, Thank you very much that did work!!

mePenny

"Jacob Skaria" wrote:

> Try
>
> =12500-SUM(A7:A9)
>
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "mePenny" wrote:
>
> > I need help updating a single cell formula.
> >
> > G4 has a formula of *=12500-A7
> >
> > I would like to update this so that A7, A8, A9 are added together then
> > subtracted from 12500.
> >
> > Any help would be greatly appreciated.
> >
> > mePenny

's Computer Specifications

Bernard,

Thank you for all your help!! it works!~!!!

"Bernard Liengme" wrote:

> =12500-SUM(A7:A9)
> OR
> =12500 - A7 - A8 - A9
> OR
> 12500 - (A7 + A8 + A9)
> best wishes
> --
> Bernard Liengme
> http://people.stfx.ca/bliengme
> Microsoft Excel MVP
>
> "mePenny" <(E-Mail Removed)> wrote in message
> news:47A0D90D-164B-4821-9315-(E-Mail Removed)...
> > I need help updating a single cell formula.
> >
> > G4 has a formula of *=12500-A7
> >
> > I would like to update this so that A7, A8, A9 are added together then
> > subtracted from 12500.
> >
> > Any help would be greatly appreciated.
> >
> > mePenny
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Addition/Subtraction	Steph	Microsoft Access Queries	2	25th Jun 2008 08:05 PM
Subtraction/addition	Cobra	Microsoft Excel Misc	7	8th May 2008 03:40 AM
Enumeration Addition/Subtraction - I need an example, please	muler	Microsoft C# .NET	3	12th Dec 2006 03:06 PM
Error in Addition and Subtraction	=?Utf-8?B?c3RhdDcyMQ==?=	Microsoft Excel Misc	2	9th Aug 2005 11:54 PM
Addition to Subtraction?	HessInAMess	Microsoft Excel Misc	1	2nd Aug 2004 09:00 PM