# how do I use +-*/ in one formula

1. ## how do I use +-*/ in one formula

A1 B1 C1 D1
2 4 3 2
2
2
2
2
how do i add A1 *B1 -C1 and then / it by D1

2. ## Re: how do I use +-*/ in one formula

What exactly do you want to add, what to subtract (from what?) and divide by what?

--
Kind regards,

Niek Otten

"topjob" <topjob@discussions.microsoft.com> wrote in message news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
| A1 B1 C1 D1
| 2 4 3 2
| 2
| 2
| 2
| 2
| how do i add A1 *B1 -C1 and then / it by D1

3. ## Re: how do I use +-*/ in one formula

"Niek Otten" wrote:

> What exactly do you want to add, what to subtract (from what?) and divide by what?
>
> --
> Kind regards,
>
> Niek Otten
>
> "topjob" <topjob@discussions.microsoft.com> wrote in message news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
> | A1 B1 C1 D1
> | 2 4 3 2
> | 2
> | 2
> | 2
> | 2
> | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1
>
>
>

4. ## Re: how do I use +-*/ in one formula

topjob, try =(A1*B1-C1)/D1 is that what you need?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"topjob" <topjob@discussions.microsoft.com> wrote in message
news:60A9F58B-AAE6-42FA-9AE3-9DE107D34E8F@microsoft.com...
>
>
> "Niek Otten" wrote:
>
>> What exactly do you want to add, what to subtract (from what?) and divide
>> by what?
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "topjob" <topjob@discussions.microsoft.com> wrote in message
>> news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
>> | A1 B1 C1 D1
>> | 2 4 3 2
>> | 2
>> | 2
>> | 2
>> | 2
>> | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1
>>
>>
>>

5. ## Re: how do I use +-*/ in one formula

=(A1*B1-C1)/D1

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"topjob" <topjob@discussions.microsoft.com> wrote in message
news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
> A1 B1 C1 D1
> 2 4 3 2
> 2
> 2
> 2
> 2
> how do i add A1 *B1 -C1 and then / it by D1

6. ## Re: how do I use +-*/ in one formula

topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
news:%23X4VbZ%23XGHA.4120@TK2MSFTNGP03.phx.gbl...
> topjob, try =(A1*B1-C1)/D1 is that what you need?
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "topjob" <topjob@discussions.microsoft.com> wrote in message
> news:60A9F58B-AAE6-42FA-9AE3-9DE107D34E8F@microsoft.com...
>>
>>
>> "Niek Otten" wrote:
>>
>>> What exactly do you want to add, what to subtract (from what?) and
>>> divide by what?
>>>
>>> --
>>> Kind regards,
>>>
>>> Niek Otten
>>>
>>> "topjob" <topjob@discussions.microsoft.com> wrote in message
>>> news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
>>> | A1 B1 C1 D1
>>> | 2 4 3 2
>>> | 2
>>> | 2
>>> | 2
>>> | 2
>>> | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1
>>>
>>>
>>>

>
>

7. ## Re: how do I use +-*/ in one formula

YES, exactly what I needed Thankyou

"Paul B" wrote:

> topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Paul B" <to_much_spam_to_list@nospam.com> wrote in message
> news:%23X4VbZ%23XGHA.4120@TK2MSFTNGP03.phx.gbl...
> > topjob, try =(A1*B1-C1)/D1 is that what you need?
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "topjob" <topjob@discussions.microsoft.com> wrote in message
> > news:60A9F58B-AAE6-42FA-9AE3-9DE107D34E8F@microsoft.com...
> >>
> >>
> >> "Niek Otten" wrote:
> >>
> >>> Please be more precise
> >>> What exactly do you want to add, what to subtract (from what?) and
> >>> divide by what?
> >>>
> >>> --
> >>> Kind regards,
> >>>
> >>> Niek Otten
> >>>
> >>> "topjob" <topjob@discussions.microsoft.com> wrote in message
> >>> news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
> >>> | A1 B1 C1 D1
> >>> | 2 4 3 2
> >>> | 2
> >>> | 2
> >>> | 2
> >>> | 2
> >>> | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1
> >>>
> >>>
> >>>

> >
> >

>
>
>

8. ## Re: how do I use +-*/ in one formula

Your welcome, thanks for the feedback

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"topjob" <topjob@discussions.microsoft.com> wrote in message
> YES, exactly what I needed Thankyou
>
> "Paul B" wrote:
>
> > topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Paul B" <to_much_spam_to_list@nospam.com> wrote in message
> > news:%23X4VbZ%23XGHA.4120@TK2MSFTNGP03.phx.gbl...
> > > topjob, try =(A1*B1-C1)/D1 is that what you need?
> > > --
> > > Paul B
> > > Always backup your data before trying something new
> > > Please post any response to the newsgroups so others can benefit from

it
> > > Feedback on answers is always appreciated!
> > > Using Excel 2002 & 2003
> > >
> > > "topjob" <topjob@discussions.microsoft.com> wrote in message
> > > news:60A9F58B-AAE6-42FA-9AE3-9DE107D34E8F@microsoft.com...
> > >>
> > >>
> > >> "Niek Otten" wrote:
> > >>
> > >>> Please be more precise
> > >>> What exactly do you want to add, what to subtract (from what?) and
> > >>> divide by what?
> > >>>
> > >>> --
> > >>> Kind regards,
> > >>>
> > >>> Niek Otten
> > >>>
> > >>> "topjob" <topjob@discussions.microsoft.com> wrote in message
> > >>> news:FAC9CF8F-E0ED-4FDB-9425-879E0D7FD966@microsoft.com...
> > >>> | A1 B1 C1 D1
> > >>> | 2 4 3 2
> > >>> | 2
> > >>> | 2
> > >>> | 2
> > >>> | 2
> > >>> | how do i add A1:A5 then *B1then -C1 and then divide the answer by

D1
> > >>>
> > >>>
> > >>>
> > >
> > >

> >
> >
> >

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1