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
- Is this income indian or foreign income?
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Tds on building rent monthly
- RCM INVOICING FROM NOV-2024
- Should I report my US salary for January, February, March in Schedule FA?
- GST ON EXPORT COMMISSION
- Confusion around Form 26QB fields
- Adjustment entry in the case of Individual and HUF on 31st March
- Stock difference tax applicable on composite rate or normal rate
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- 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?
Trending Online Classes
CAclubindia
