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

Excel Calculation
 

=if(a149.99,2.40,(a1-10)*6/100)


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=563688

Excel Calculation
 

if you enter value in cell A1, try this

=IF(A149.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

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" wrote in message
...
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

Excel Calculation
 

"BrianC500" wrote in message
...
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(A149.99,39.99,A1-10)
--
David Biddulph

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" wrote in message
...
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

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(A149.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