Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formula help

=if(k9=0,"put a non-zero number in K9",if(c9=0,0,c9+1)*d9/k9)

SoggyCashew wrote:

Hello I have this formula that works so far but I need to divide the D9 by K9
and cant figure out the formula... Here is what I have so far but get the div
error.
=IF( C9=0, 0, C9+1)*D9/K9

--
Thanks,
Chad


--

Dave Peterson