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
- Tax on Deemed Capital Gain
- Exiting partner in partnership firm in gst portal
- Type of Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Regarding ITR filing with more value than showing in AIS/TIS
- Average Cost Of High Quality Diamonds
- ITR-3 File/Error Found
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- TDS _Long term Capital Gain ref.sec 214 Table 2
- Rental income of jointly held property
- Can a single LLP in India legally operate multiple unrelated businesses (Travel, Cloud Kitchen, Ecom
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
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
