# Excel Calculation

1. ## 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  Register To Reply

2. =if(a1>49.99,2.40,(a1-10)*6/100)  Register To Reply

3. ## 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  Register To Reply

4. ## 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  Register To Reply

5. ## Re: Excel Calculation

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

>
>
>  Register To Reply

6. ## 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
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
>
>  Register To Reply