| QUESTIONS | CATEGORIES | BLOG | PROFILE | Login | Register |
ASK QUESTION
Computers → Computer software → Spreadsheet software → Microsoft Excel
ANSWERS: 3
  • Brian I
    I may have misunderstood what you want to do, if so I apologise. Say you have a figure in cell A1 and a larger figure in A2 and you want to know by what % it has risen. The formula '=(A2-A1)/A1*100' will do it.
    No comments
  • Randy
    If your original number is in cell A1 and the new number is in A2, the formula is: =A2/A1-1 then format as a percentage If you have a series of numbers (i.e. annual increase) the formula is: =((last number)/(first number))^(1/(count-1))
    No comments
  • Chee06
    =((LN(A1)-LN(A20))/COUNTA(A1:A20))*100
    No comments

RELATED QUESTIONS

ABOUT ANSWERBAG

Answerbag wants to provide a service to people looking for answers and a good conversation. Ask away and we will do our best to answer or find someone who can.We try to vet our answers to get you the most acurate answers.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy