Thread: #Div/0
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default #Div/0

"H" wrote:
is there a way to do something like this for - I'm getting the
#Div/0 on a few cuz T is 0
=+(X2/T2)*12


=if(T2=0, "", 12*X2/T2)

That results in a cell that appears blank if T2 is zero. Alternatively,
replace "" with anything else you wish, for example 0.