View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nectar
 
Posts: n/a
Default Create an increase or decrease formula with zero %

PLease help i'm trying to set up my worksheet to calculate the increase or
decrease percentage from YTDr to LYTD

YTD= 200 LYTD=145 =.38% formula =(a1-b1)/abs(b1) but when I have a zero my
formula wont work please help me to create a formula that could work with
zeros

Thanks a lot my saviors !!!!