"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