+ Reply to Thread
Results 1 to 8 of 8

how do I use +-*/ in one formula

  1. #1
    topjob
    Guest

    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. #2
    Niek Otten
    Guest

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

    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



  3. #3
    topjob
    Guest

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



    "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
    >
    >
    >


  4. #4
    Paul B
    Guest

    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:
    >
    >> 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
    >>
    >>
    >>




  5. #5
    Peo Sjoblom
    Guest

    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. #6
    Paul B
    Guest

    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:
    >>
    >>> 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
    >>>
    >>>
    >>>

    >
    >




  7. #7
    topjob
    Guest

    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. #8
    Paul B
    Guest

    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
    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
    > > >>>
    > > >>>
    > > >>>
    > > >
    > > >

    > >
    > >
    > >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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