Is there a percentage formula!
Closed
Krishna33
Posts
1
Registration date
Wednesday 11 March 2015
Status
Member
Last seen
11 March 2015
-
11 Mar 2015 à 01:57
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 11 Mar 2015 à 08:49
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 11 Mar 2015 à 08:49
Related:
- Percentage formula in excel marksheet
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
- Number to words in excel formula - Guide
- Formula to calculate vat in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
11 Mar 2015 à 08:49
11 Mar 2015 à 08:49
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.
