+ Reply to Thread
Results 1 to 6 of 6

Excel Calculation

  1. #1
    BrianC500
    Guest

    Excel Calculation

    I need a calculation to do the following; If the value entered is above
    £49.99 I need it to show 6% of £39.99. If the value entered in the cell is
    less than £49.99 I need it to show 6% of the value entered less £10.00.
    i.e. if over £49.99 it would show £2.40
    if the value was £44.99 I would need it show 6% of £34.99
    How can I do this? Any help would be greatly appreciated

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007
    =if(a1>49.99,2.40,(a1-10)*6/100)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Bill Ridgeway
    Guest

    Re: Excel Calculation

    You have stated what you want done if the value entered is less than 49.99
    and more than 49.99 but not what you want if the value is exactly 49.99. I
    suspect you mean less than 50 and equal or more than 50. A popular mistake.
    Would you let me know what you intended before I assume and put finger to
    keyboard.

    Regards.

    Bill Ridgeway
    Computer Solutions

    "BrianC500" <BrianC500@discussions.microsoft.com> wrote in message
    news:B13D660E-E633-4047-B56B-1440E8334D90@microsoft.com...
    >I need a calculation to do the following; If the value entered is above
    > 49.99 I need it to show 6% of 39.99. If the value entered in the cell is
    > less than 49.99 I need it to show 6% of the value entered less 10.00.
    > i.e. if over 49.99 it would show 2.40
    > if the value was 44.99 I would need it show 6% of 34.99
    > How can I do this? Any help would be greatly appreciated




  4. #4
    David Biddulph
    Guest

    Re: Excel Calculation

    "BrianC500" <BrianC500@discussions.microsoft.com> wrote in message
    news:B13D660E-E633-4047-B56B-1440E8334D90@microsoft.com...
    >I need a calculation to do the following; If the value entered is above
    > 49.99 I need it to show 6% of 39.99. If the value entered in the cell is
    > less than 49.99 I need it to show 6% of the value entered less 10.00.
    > i.e. if over 49.99 it would show 2.40
    > if the value was 44.99 I would need it show 6% of 34.99
    > How can I do this? Any help would be greatly appreciated


    =6%*IF(A1>49.99,39.99,A1-10)
    --
    David Biddulph



  5. #5
    BrianC500
    Guest

    Re: Excel Calculation

    Thanks for the reply Bill.

    The values are; "greater than 49.99" and "equal to or less than 49.99"

    Bill Ridgeway" wrote:

    > You have stated what you want done if the value entered is less than 49.99
    > and more than 49.99 but not what you want if the value is exactly 49.99. I
    > suspect you mean less than 50 and equal or more than 50. A popular mistake.
    > Would you let me know what you intended before I assume and put finger to
    > keyboard.
    >
    > Regards.
    >
    > Bill Ridgeway
    > Computer Solutions
    >
    > "BrianC500" <BrianC500@discussions.microsoft.com> wrote in message
    > news:B13D660E-E633-4047-B56B-1440E8334D90@microsoft.com...
    > >I need a calculation to do the following; If the value entered is above
    > > £49.99 I need it to show 6% of £39.99. If the value entered in the cell is
    > > less than £49.99 I need it to show 6% of the value entered less £10.00.
    > > i.e. if over £49.99 it would show £2.40
    > > if the value was £44.99 I would need it show 6% of £34.99
    > > How can I do this? Any help would be greatly appreciated

    >
    >
    >


  6. #6
    BrianC500
    Guest

    Re: Excel Calculation

    Hi,

    Thanks for that it really did help. I thought I might be able to adjust the
    figures for a similar calculation but, I am now getting a negative. Could you
    help again please?
    I now need the same calculation for;
    Value in cell A1 if greater or equal to 499.99 I need 6% of £449.99. If the
    value in A1 is less than £499.99 I need 6% of A1 less £50. If the Value in A1
    is less than £50.00 I need a Zero. At the moment if I enter less than £50 I
    get a minus figure.
    Any help would be greatly appreciated.

    Thank you

    Brian

    "starguy" wrote:

    >
    > if you enter value in cell A1, try this
    >
    > =IF(A1>49.99,39.99*0.06,IF(A1<49.99,(A1-10)*0.06))
    >
    > BrianC500 Wrote:
    > > I need a calculation to do the following; If the value entered is above
    > > £49.99 I need it to show 6% of £39.99. If the value entered in the
    > > cell is
    > > less than £49.99 I need it to show 6% of the value entered less
    > > £10.00.
    > > i.e. if over £49.99 it would show £2.40
    > > if the value was £44.99 I would need it show 6% of £34.99
    > > How can I do this? Any help would be greatly appreciated

    >
    >
    > --
    > starguy
    > ------------------------------------------------------------------------
    > starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
    > View this thread: http://www.excelforum.com/showthread...hreadid=563688
    >
    >


+ 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