Hey everyone.

Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in L13
unless all of the cells mentioned have a value in them.

Chers
David

Roger if your out there HELP!

=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N ",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"" ,SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)

=IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula)

Regards

Trevor


"DavidB" wrote in message
...
Hey everyone.

Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in
L13
unless all of the cells mentioned have a value in them.

Chers
David

Roger if your out there HELP!

=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N ",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"" ,SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)

Trevor, thanks for the help, however when I placed your formula at the
begining of mine I couldn,t get out of error window that kept popping
up....I've done something wrong but I have no idea what?

Cheers
David

"Trevor Shuttleworth" wrote:

=IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula)

Regards

Trevor


"DavidB" wrote in message
...
Hey everyone.

Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in
L13
unless all of the cells mentioned have a value in them.

Chers
David

Roger if your out there HELP!

=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N ",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"" ,SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)

I give in; it should look like this:

=IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"",
IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N" ,AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"", SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5))

Note: you need to lose the "=" sign from the beginning of your formula.
Could that be the problem ?

Regards

Trevor


"Trevor Shuttleworth" wrote in message
...
=IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula)

Regards

Trevor


"DavidB" wrote in message
...
Hey everyone.

Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into
the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in
L13
unless all of the cells mentioned have a value in them.

Chers
David

Roger if your out there HELP!

=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N ",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"" ,SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)