| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you write format results of a function within a function? | Excel Worksheet Functions | |||
| adjust the range in a long column of formulas to accomodate new da | Excel Worksheet Functions | |||
| Excel should accomodate more number of rows than 65536, to load l. | Excel Discussion (Misc queries) | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| Code modification to accomodate scaling and print areas. | Excel Programming | |||
Hybrid Mode
