| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
improve formula, Possible Genious needed !!!
=IF(AND(OR(C5=V13,C5=V15,C5=V16),C8C7,(C8-C7)*24W10,(V2-C7)*24=W13),W13,IF(AND(C5=V14,(V2-C7)*24=W14),W14,IF(AND(OR(C5=V13,C5=V15,C5=V16),C 7<V2,(V2-C7)*24<W13),(V2-C7)*24,IF(AND(C5=V14,C7<V2,(V2-C7)*24<W14),(V2-C7)*24,IF(AND(OR(C5=V13,C5=V15,C5=V16),C7C8,OR(C8 <V2,C8W2)),W13,IF(AND(C5=V14,C7C8,OR(C8<V2,C8W2 )),W14,IF(AND(C7=W2,C5<V9,C5<V10,C5<V11,C5<V1 2,C5<V18,C5<V19,C5<V14),W13,0)))))))
i HAVE APARENTLY RAN OUT OF OPTIONS (7) IN THIS FORMULA. bUT NEED MORE OPTIONS YET. iS THER ANYONE WHO HAS THE INTELIGENCE TO LESSEN THE ABOVE FORMULA TO ALLOW FOR YET MORE OPTIONS? CTM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| IF-THEN Formula help needed | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
