Thread: Formula Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DavidB DavidB is offline
external usenet poster
 
Posts: 41
Default 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