Baisic formula

W

walkerT

I need a formula that will give me a reduction in %: Example

Cell A is 26.02%
Cell B is 24.22%

I need a formula that would give me the reduction difference as a
percantage. So if my percentage was 26.02% and now its 24.22% how much of a
discout have I received based on a percenatge.
 
D

Dave F

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.

Dave
 
J

JE McGimpsey

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").
 
Top