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
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- TDS U/S. 194NF
- Applicable TDS rate for sale of property in Nov 2024
- GST ON EXPORT COMMISSION
- Should I report my US salary for January, February, March in Schedule FA?
- 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?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
