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
- TDS 194-T applicability
- GST ITC REVERSE
- Fixe term employment
- Is any professional CA is here please reply
- Consolidated financials
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Section 50-fixed asset-->building ceases to exist
- Putting a heading on received mail
- Regarding Applicability of Tax Audit u/s 44AB
- TDS on TRUST
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
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
