Thread: how to set up an IF formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default how to set up an IF formula
Gene wrote:
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.

Why would a negative number divided by a negative number not be positive?
Reply With QuoteReply With Quote