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

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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

Thanks Mark, can you look at this and tell me why I'm getting a crazy output
(ie a 5 figure percentage out of 100) in my destination cell H13.
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2))))

Cheers
David

"MarkN" wrote:

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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

Hi David,
I have added the number 50 to all relevant cells in the first OR and get the
answer 90. So I think that your cell formattting is producing the unexpected
result. Right-click on the formula cell, choose Format Cells, on the Number
tab, choose General. Does this solve the problem, if not:
-reply with what it says is the format box and
-suggest some realistic numerical data that I can use.
--
Thanks,
MarkN


"DavidB" wrote:

Thanks Mark, can you look at this and tell me why I'm getting a crazy output
(ie a 5 figure percentage out of 100) in my destination cell H13.
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2))))

Cheers
David

"MarkN" wrote:

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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

Mark, while I was waiting I messed around with some more with this formula
and now I get a 3 figure % (eg 139%) in H13. However I did try what you just
suggested and when I chose the General option it gave me 138.71%. I would be
more than happy to supply you with realistic data but I'm more than willing
to email you the speadsheet that you might get a better understanding of what
I'm trying to achieve...once you have a look at this speadsheet you'll
understand immediately.

Cheers
David

"MarkN" wrote:

Hi David,
I have added the number 50 to all relevant cells in the first OR and get the
answer 90. So I think that your cell formattting is producing the unexpected
result. Right-click on the formula cell, choose Format Cells, on the Number
tab, choose General. Does this solve the problem, if not:
-reply with what it says is the format box and
-suggest some realistic numerical data that I can use.
--
Thanks,
MarkN


"DavidB" wrote:

Thanks Mark, can you look at this and tell me why I'm getting a crazy output
(ie a 5 figure percentage out of 100) in my destination cell H13.
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2))))

Cheers
David

"MarkN" wrote:

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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

Sorry I forgot to paste the formula....
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2)/100)))

"MarkN" wrote:

Hi David,
I have added the number 50 to all relevant cells in the first OR and get the
answer 90. So I think that your cell formattting is producing the unexpected
result. Right-click on the formula cell, choose Format Cells, on the Number
tab, choose General. Does this solve the problem, if not:
-reply with what it says is the format box and
-suggest some realistic numerical data that I can use.
--
Thanks,
MarkN


"DavidB" wrote:

Thanks Mark, can you look at this and tell me why I'm getting a crazy output
(ie a 5 figure percentage out of 100) in my destination cell H13.
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2))))

Cheers
David

"MarkN" wrote:

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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

Just before you send it to me, what result are you hoping to get?
--
Thanks,
MarkN


"DavidB" wrote:

Sorry I forgot to paste the formula....
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2)/100)))

"MarkN" wrote:

Hi David,
I have added the number 50 to all relevant cells in the first OR and get the
answer 90. So I think that your cell formattting is producing the unexpected
result. Right-click on the formula cell, choose Format Cells, on the Number
tab, choose General. Does this solve the problem, if not:
-reply with what it says is the format box and
-suggest some realistic numerical data that I can use.
--
Thanks,
MarkN


"DavidB" wrote:

Thanks Mark, can you look at this and tell me why I'm getting a crazy output
(ie a 5 figure percentage out of 100) in my destination cell H13.
=IF(OR(AB13="",AF13="",AH13="",AJ13="",AT13="",BF1 3="",BT13="",BY13="",CA13="",CE13="",CG13=""),"",I F(OR(AB13="N",AF13="N",AH13="N",AJ13="N",AT13="N", BF13="N",BT13="N",BY13="N",CA13="N",CE13="N",CG13= "N"),"",IF(OR(AB13="R",AF13="R",AH13="R",AJ13="R", AT13="R",BF13="R",BT13="R",BY13="R",CA13="R",CE13= "R",CG13="R"),"",SUM(AB13*0.1,AF13*0.2,AH13*0.18,A J13*0.2,AT13*0.2,BF13*0.2,BT13*0.2,BY13*0.11,CA13* 0.13,CE13*0.08,CG13*0.2))))

Cheers
David

"MarkN" wrote:

Hi David,
You can use up to 30 conditions inside an OR function, I think you have too
many.
--
Thanks,
MarkN


"DavidB" wrote:

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