A1 B1 C1 D1
2 4 3 2
2
2
2
2
how do i add A1 *B1 -C1 and then / it by D1
A1 B1 C1 D1
2 4 3 2
2
2
2
2
how do i add A1 *B1 -C1 and then / it by D1
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 *B1 -C1 and then / it by D1
"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
>
>
>
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
>>
>>
>>
=(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
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
>>>
>>>
>>>
>
>
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
> >>>
> >>>
> >>>
> >
> >
>
>
>
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
news:6886D57D-E452-40BA-A838-AD6463794550@microsoft.com...
> 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)
Bookmarks