Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to get this formula to work.
=IF(OR(K2="L",K2="M",E2<=10),120,60,IF(OR(K2="L",K 2="M",E2=11,E2=12,E2=13,E2=14),90,60,IF(OR(K2="L", K2="M",E2=15,E2=16,E2=17),45,45,IF(OR(K2="L",K2="M ",K2="H",E217),30,30)))) But it tells me that I have too many arguements within the function. The problem is they are required to get the answer I am looking for. What I'm asking is: If column K has an L or M and column E is <=10, then the value is 120, if false, 60. If in K, L and M are equal to 11 through 14 in column E, then the value is 90 and if false 60, IF in column K, L and M are equal to 15-17 in column E then the answer is 45 and if not it is 45, and if in column K, L and M are greater than 17 in column E, then the answer is 30 and if mot it is 30. Please Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |