| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long "IF" formula
I thought I would post part of the formula that you all have helped me with
just to say thank you. I got everything running now. There were 7 formulas like this one plus 2 data tables one of which had 12 "TRUE" formulas =ROUND(IF(O63=TRUE,AVERAGE(P45:Q46),IF(D61=TRUE,AV ERAGE(P44:Q46),IF(E61=TRUE,AVERAGE(P43:Q46),IF(F61 =TRUE,AVERAGE(P42:Q46),IF(G61=TRUE,AVERAGE(P41:Q46 ),IF(H61=TRUE,AVERAGE(P40:Q46),P46)))))),0) =AND(M63=TRUE,H46=H45,H45=H44,H44=H43,H43=H42,H41= H42,H41=H40) =IF(O63=TRUE,"The average ",IF(D61=TRUE,"The average ",IF(E61=TRUE,"The average ",IF(F61=TRUE,"The average ",IF(G61=TRUE,"The average ",IF(H61=TRUE,"The average ","The ")))))) I got everything running just like I wanted, thank you sooo much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| While using find and replace i am getting "formula too long" | Excel Discussion (Misc queries) | |||
| "formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
| "Formula too long" when changing linked sources?? | Excel Discussion (Misc queries) | |||
| Error message "formula is too long" | Excel Discussion (Misc queries) | |||
| Error message "formula is too long" | Excel Worksheet Functions | |||
Threaded Mode
