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