how do i set up autosum as a %

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to set up figures from one year to next and would like to show
difference as a %
 
=(B2/A2-1)*100

B2 has this year
A2 was last year

You can format the cell as a %, the formula would then be =B2/A2-1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel autosum problem in Excel 1
How can I set up a shortcut key for Autosum? 3
Autosum button 1
Why do I get #### when I Autosum in Excel? 2
AutoSum lost a penny 5
Data Filter and AutoSum 4
How do I make AutoSum really Sum, not Subtotal 5
Combo boxes and AutoSum 1

Back
Top