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