PDA

View Full Version : Need Help With Excel Formula



parkers
04-14-2016, 09:00 AM
Hello,

I don't know how to get this formula to work properly. I'm trying to calculate the percentage of these numbers (F10=276) and (C=136). I found this formula on another site. For some reason, this portion of the formula is not working (F10-C10)/2). Here's the formula that I'm using. Please assist. Thanks.

(F10+C10)/(F10-C10)/2*100

GTO
04-14-2016, 09:42 AM
Hi there,

I am signing out, but for anyone who may get to help you, could you clarify what you are trying to do? At least as this thick-headed blond guy reads it, you are either trying to find out what percentage of 276 is the value 136, or conversely, what percentage of 136 is 276. From your formula, you must be trying to return something else?

Mark

Aussiebear
04-16-2016, 09:32 PM
I'm guessing its just an order of precedence that might be the issue, from that which you have written.

(F10+C10)/((F10-C10)/2)*100

However if you are chasing the percentage value as GTO has suggested then its either

(F10/C10)*100 if C10 is a percentage of F10, or
(C10/F10)*100 if F10 is a percentage of C10.

SamT
04-17-2016, 08:08 AM
Average(X, Y)*100 and (X+Y)/2*100 are both the average of X & Y expressed as a percentage.

(X-Y) will be zero if X = Y.
(X+Y)/zero will raise a division by zero error in that case.

I'm not sure what 1/2 of Sum/Difference is, whether expressed as a percentage or not. The result approaches infinity as Difference approaches zero and conversely, approaches zero as Difference approaches infinity.