Thread: Why doesn't this formula work, please?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed[_7_] Ed[_7_] is offline
external usenet poster
  
Posts: 5
Default Why doesn't this formula work, please?
=IF(D26-F265,MIN(D26-F26,30),"0"). I also tried =IF(SUM(D26-F26)
5,MIN(D26-F26,30),"0"). But I keep getting "0", unless I enter a
number higher than "10", which is confusing, as the quantative value
here is 5.
Reply With QuoteReply With Quote