Help with Excel percentages
Solved/Closed
Related:
- Help with Excel percentages
- Excel marksheet percentage formula - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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