Baisic formula
 

Fair point.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"JE McGimpsey" wrote:

Yeah, I think you're splitting hairs...

To me, a plain number indicating a reduction is always negative. If the
number's positive, it's not a reduction, it's an increase. It's the way
I build my applications, and the way most, though certainly not all, of
my clients prefer to have numbers reported.

However, you may be exactly correct about what the OP intended (it's why
I prefaced my answer with "if I understand you correctly").



In article ,
Dave F wrote:

With your formula, if B1 = .5 and A1 = .75 you will get a -33.33% decrease.
A negative decrease, to me, sounds like a positive increase; i.e., a double
negation. Wouldn't you want 1 - (.5/.75) = .33; i.e., a 33.33% decrease?

Though I've been accused of splitting hairs before.