Your formula states *GREATER* then 5!

Maybe you actually want this:

=IF(D26-F26=5,MIN(D26-F26,30),0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ed" wrote in message
...
=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.