| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to replace Formula
=IF(AND(C5<"Non
U/G",C5<"Delta",C7V2,C7<W2,C8W2),"0.75",IF(AND(C5 ="Delta",C7V2,C7<W2,C8W2),"0.5",IF(AND(C5<"N on U/G",C5<"Delta",C7<V2,C8<V2),"1.5",IF(AND(,C5="Delt a",C7<V2,C8<V2),"1",IF(AND(C5<"Non U/G",C5<"Delta",C7<V2,C8=W2),"0.75",IF(AND(C5="Del ta",C7<V2,C8=W2),"0.5",IF(AND(C5<"Non U/G",C5<"Delta",C7<V2,C8V2,C8<=W2),"0.75",IF(AND(C 7<V2,C8V2,C8<=W2),"0.5","0")))))))) I think i am at the end of the fomula limit. How to i enter this as code? -- Regards Corey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace html code - formula too long | Excel Discussion (Misc queries) | |||
| Need code to replace part of a range within a formula with a defined name | Excel Programming | |||
| Replace code | Excel Programming | |||
| Replace Symbol "Code(63)" | Excel Worksheet Functions | |||
| Replace Code Programmatically | Excel Programming | |||
Threaded Mode
