hi
i have the following formula that reurns the efficiency of a team
this works great until a zero score is entered and 60 minutes is
entered as a downtime


(C27/($C$147*(C142-C25)/C142)

the cells are as follows
c27 = 0 score
C147 = 78 target
C142 = 60 minutes available
c25 = 60 downtime

How can i put a zero in to the result cell if the result is #div/0!

thanks for your help

kevin