Vlookup
 

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?


--
theukego
------------------------------------------------------------------------
theukego's Profile: http://www.excelforum.com/member.php...o&userid=28781
View this thread: http://www.excelforum.com/showthread...hreadid=486791

Vlookup
 

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


"theukego" wrote:


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?


--
theukego
------------------------------------------------------------------------
theukego's Profile: http://www.excelforum.com/member.php...o&userid=28781
View this thread: http://www.excelforum.com/showthread...hreadid=486791

Vlookup
 

Hi

Whatever cell holds the calculation of the amount add

=IF(AND(amount299,amount<=350),amount*97.5%,IF(am ount350,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(amount299,amount<=350),amount*2.5%,IF(amo unt350,amount*5%,amount))

Regards

Roger Govier


theukego wrote:
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?