View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gene Gene is offline
external usenet poster
 
Posts: 100
Default how to set up an IF formula

formula: sum(B1-C1)/C1. B1 is 200, C1 is 100 result is 100%. But when B1 is
(200) and C1 is (100) the result is still 100% but should be (100%). How can
I set-up formula so it correctly recognizes both circumstances?

As always thank YOU.
--
Gene