How do I write an IF function to accomodate equal to or more than
 

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

How do I write an IF function to accomodate equal to or more than
 

=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

How do I write an IF function to accomodate equal to or more than
 

I will write this referring to cell A1 for the amount:
=IF(A1=200,Discount1,IF(AND(A1200,A1<300),Discoun t2,IF(A1=300,Discount3,A1)))
--
- K Dales


"William Faro" wrote:

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