Percentage
This query is : Resolved
10 December 2013
what is d function for percentage in ms excel
10 December 2013
Percent is nothing but denotation of object in share of 100.
In Excel 2007 to 2013 in HOME ribbon 4th TAB / Block is of Number having % Sign.
If you want to represent net profit percent and x is net profit y is sales then in formula bar press = x / y.
After pressing enter again select the sale having above formula and then by mouse click % sign in Number tab. In same tab by pressing left aero key select decimal point up to which value is desired.
In Excel 2007 to 2013 in HOME ribbon 4th TAB / Block is of Number having % Sign.
If you want to represent net profit percent and x is net profit y is sales then in formula bar press = x / y.
After pressing enter again select the sale having above formula and then by mouse click % sign in Number tab. In same tab by pressing left aero key select decimal point up to which value is desired.
24 December 2013
there is no function relating to %. You have to use symbol specified in number tab (MS Excel 07)
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Applicability
- Is Aadhar PAN linking required for opening bank account?
- Where to show the RCM on Rent paid to unregistered landlord
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Application of 115BAC
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- TDS NUMBER SURRENDER
- GSTR-3B - Do I file nil when there is no sale but I've bought raw materials
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Whether still royalty
- 20% OF DEMAND PAYMENT IN APPEAL
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
