View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NBVC[_67_] NBVC[_67_] is offline
external usenet poster
 
Posts: 1
Default How to not get '0' or '#DIV/0!' in a cell with a percentage formul


If you don't want to show 0 or #Div/0 results.. then

=IF(OR(A2="",B2="",B2=0),"",A2/B2)

or

=IF(SUM(A2,B2)=0,"",A2/B2)


--
NBVC

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