Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula Error
Could some kind person check this for me and tell me where the error is in
this formula please as I keep getting that dredded error message "This Formula Contains An Error" =IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BG1 3="",BT13="",BY13="",CA13="",CE13="",CG13="",AB13= "N",AF13="N",AH13="N",AJ13="N",AT13="N",BG13="N",B T13="N",BY13="N",CA13="N",CE13="N",CG13="N",AB13=" R",AF13="R",AH13="R",AJ13="R",AT13="R",BG13="R",BT 13="R",BY13="R",CA13="R",CE13="R",CG13="R"),"",SUM (AB13*0.10,AF13*0.2,AH13*0.18,AJ13*0.20,AT13*0.2,B G13*0.2,BT13*0.2,BY13*0.11,CA13*0.13,CE13*0.08,CG1 3*0.2)/100) All the above are source cells and H13 is the destination cell where I'm entering this formula Cheers David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula Recalculation Error | Excel Worksheet Functions | |||
Let me save/close EXCEL if a formula I put in has an error in it | Setting up and Configuration of Excel | |||
I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
Formula error... | Excel Discussion (Misc queries) |