how to set up an IF formula
Maybe
=(B1-C1)/MIN(B1,C1)
Mike
"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.
--
Gene
|