Help with Excel percentages
Solved/Closed
Related:
- Help with Excel percentages
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 11, 2010 at 06:31 PM
Mar 11, 2010 at 06:31 PM
From what I understood from your question
=IF(A5>B5, (B5-C5)/(A5-B5), "")
you can format this cell to be %age
or you can try this
=IF(A5>B5, 100 *(B5-C5)/(A5-B5), "")
=IF(A5>B5, (B5-C5)/(A5-B5), "")
you can format this cell to be %age
or you can try this
=IF(A5>B5, 100 *(B5-C5)/(A5-B5), "")
Mar 15, 2010 at 01:07 PM
Came in Monday morning and u answered with correct formula. Have a great day