Is there a percentage formula!
Closed
Krishna33
Posts
1
Registration date
Wednesday March 11, 2015
Status
Member
Last seen
March 11, 2015
-
Mar 11, 2015 at 01:57 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Mar 11, 2015 at 08:49 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Mar 11, 2015 at 08:49 AM
Related:
- Is there a percentage formula!
- Excel marksheet percentage formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Mar 11, 2015 at 08:49 AM
Mar 11, 2015 at 08:49 AM
Hello,
Unless I misunderstand the question...
The display as a percentage is handled by formatting.
The number can be manipulated in any function common in Excel.
In A1 you might put 1. (1 being 100%)
In B2 you might put =A1*.7
In C2 you might put =A1*.3
If formatted as percentages in all three cells the result should be:
A1 = 100%
B2 = 70%
C2 = 30%
Hope that helps.
Unless I misunderstand the question...
The display as a percentage is handled by formatting.
The number can be manipulated in any function common in Excel.
In A1 you might put 1. (1 being 100%)
In B2 you might put =A1*.7
In C2 you might put =A1*.3
If formatted as percentages in all three cells the result should be:
A1 = 100%
B2 = 70%
C2 = 30%
Hope that helps.
