Excel
This query is : Resolved
24 June 2013
how to use if function in excel for following
basic pay is rs1000
so
EA@10%of basic salary for officer drwaing a basic pay of rs 4500 ad abovee, subjected to maximum of rs 600pm.
plaese rply ASAP
basic pay is rs1000
so
EA@10%of basic salary for officer drwaing a basic pay of rs 4500 ad abovee, subjected to maximum of rs 600pm.
plaese rply ASAP
24 June 2013
you can use IF function.
24 June 2013
sir that s what i knw i need to use if function but indeed how to do tat if u can tell den i ll b higly obilige..
24 June 2013
let suppose
Cell A1 = basic pay
Cell A2 = if(a1>6000,600,a1*10%)
this is result 10% of basic pay but total amount will not exceed 600.
if still have query please feel free to call 0120-4560193
Cell A1 = basic pay
Cell A2 = if(a1>6000,600,a1*10%)
this is result 10% of basic pay but total amount will not exceed 600.
if still have query please feel free to call 0120-4560193
24 June 2013
thanking thanking a lot more thanking to u finaly i bcm succeeded to wch i want to all bcs f u (y) nd yeah l8r on whn i rqr i ll make call may I?
24 June 2013
you are welcome.
18 August 2013
hello will you please resolve my one more query ??
how to create purchase order for services(without item) in tally9
how to create purchase order for services(without item) in tally9
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
- Unregistered suppliers utility
- Difference between Date of Payment and Date of Deduction?
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- ITDS U/S.194T of Firm
- Bank details not Visible on Traces Portal
- Taxability of Partnership firm for FY 2025-26
- TDS ON EMAIL DOMAIN SERVICE BILL
- Journal entry of busniess expenses
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- 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
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
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
