Thread: Variance Report - Need to reflect 0%
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Variance Report - Need to reflect 0%
=IF(A2=0,0,B2/A2)

adapt to fit


--


Regards,


Peo Sjoblom


"JDM" wrote in message
...
Hello! I need my variance number to show 0% even when the formula's
answer
is #DIV/0!



Reply With QuoteReply With Quote