=IF(C4=200,"discount if = 200 goes here",IF(AND(C4200,C4<300),"discount
between 200 and 300 goes here",IF(C4300,"DISCOUNT OVER 300 GOES HERE","NO
DISCOUNT")))


"William Faro" wrote in message
...
In EXCEL 2003 I want to enter an IF function that will calculate discounts
if
the amount is (1) equal to 200 ( 2) more than 200 and less than 300 and
(3)
more than 300
Manty thanks for any help
--
William Faro