Thread: not sure if I'm using the correct formula for the result I want?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
NBVC[_7_] NBVC[_7_] is offline
external usenet poster
  
Posts: 1
Default not sure if I'm using the correct formula for the result I want?

Try replacing your handicap formula with:

=IF(COUNTIF(B4:C4,"0"),((SUM(B4:C4)/COUNTIF(B4:C4,"0"))-36)*0.8,0)

to avoid the #DIV/0 error...and get a 0 instead.


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=107430

Reply With QuoteReply With Quote