Vlookup

[theukego]

How can i do the following as i'm baffled:

a discount by his supplier so that, if his bill for materials in any
one month is between £300 and £350 he will receive a discount of 2.5%
and, if it is above £350 he will receive a discount of 5%. Basically i
have got a spreadsheet made up already, do i need to add a new sheet
and program it there or do i put it on the same sheet?

 

[Guest]

suppose ur value is in cell b19
then type the following formula
=IF(AND(B19>=300,B19<=350),B19*0.025,IF(B19>350,B19*0.05,"**"))
hope this will help u

 

[Roger Govier]

Hi

Whatever cell holds the calculation of the amount add

=IF(AND(amount>299,amount<=350),amount*97.5%,IF(amount>350,amount*95%,amount))
Or if you want to show the discount as a value in a separate column then
subtract if from the amount then

=IF(AND(amount>299,amount<=350),amount*2.5%,IF(amount>350,amount*5%,amount))

Regards

Roger Govier