Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Need help with an Excel formula

who's talking here?

Just Kim 5
Itty Bitty Prints 1
tracie505 1
Spunkin 2
Perfection 2
zapper007 1

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

Just Kim --- 17 years ago -

I need to Subtract column b from a then divide by column a and then multiple that by 100. I need to have this formula in column c ANY HELP?????? THANKS 

Spunkin --- 17 years ago -

hmmmm . . . . =((B1-A1)/A1)*100 maybe? 

tracie505 --- 17 years ago -

=((a#-b#)/a#)*100 Try that 

Spunkin --- 17 years ago -

I got my A and B backwards in the beginning -- thanks Tracie 

Just Kim --- 17 years ago -

Thanks! 

Just Kim --- 17 years ago -

DIDN'T WORK 

Just Kim --- 17 years ago -

I am trying to do this column b is 228 and i need to subtract column c 223 then divide by column b (228) then multiple by 100. And I cannot figure it out....help please 

Itty Bitty Prints --- 17 years ago -

=((228-223)/228)*100 or =((b1-c1)/b1)*100 You really should need that second set of parentheses, but if it works, good! 

Perfection --- 17 years ago -

try this =SUM(B1-A1)/A1*100 

Just Kim --- 17 years ago -

Thanks Chunky...that worked!!! 

Perfection --- 17 years ago -

No problem. I play in excel all the time so if you need anything just yell. 

zapper007 --- 17 years ago -

I play in excel all the time so if you need anything just ye I work in Excel with complex formulas. Same offer here... Have you taken the free tutorial in Excel? 

page 1
Login to add your comments!

see more discussions about...


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground