Formula Error

[Guest]

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 Shuttleworth]

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

Regards

Trevor

 

[Guest]

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]

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