View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Barr John Barr is offline
external usenet poster
 
Posts: 5
Default Percentage Formula Issue

=IF(ROUND((((B6-B5) /B5) * 100), 0) < 0, "0%", ROUND((((B6-B5) /B5) * 100),
0) & " %")

August B5 = 0 0% (Because there is no July entry)
September B6 = 1 100%
October B7 = 0 0% (Because we are not in October yet)

I want to show the % Increase