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
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- Carriage Road Act, 2007 read with Carriage by Road Rules, 2011
- Same demand raised for original as well as rectification request return
- Sale of property held jointly with a non resident Indian
- RELATED TO TRIBUNAL APPEAL
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- ITR 4 and Bank transactions
- IS AUDIT MANDATORY IF COMMISSION INCOME IS MORE THAN 50 LAKH
- Difference between Date of Payment and Date of Deduction?
- Journal entry of busniess expenses
- Cash balance limit and property purchases limit
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
