Excel Calculation

B

BrianC500

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
 
S

starguy

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))
 
B

Bill Ridgeway

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
 
D

David Biddulph

BrianC500 said:
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
Click to expand...

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

BrianC500

Thanks for the reply Bill.

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

BrianC500

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
 
Top