| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Function IF AND
Hi Not too good at maths, trying to produce a formula to calulate discounts.
if a0.25 and b10 discount =Z if a0.25 and b49 discount =Y if a1 and b10 discount =X if a1 and b49 discount =W if b499 Discount =V I Have "=IF(AND(C40.25,B510),I15,0)" for 1st line but can't seem to add other lines to the formula is it possible to have 1 formula that carries out all the calulations? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Threaded Mode
