Excel formula???
This query is : Resolved
16 April 2015
Hi,
Is there any formula in excel that will define the function of one cell depend upon the result of another cell. If the result of one cell is "Yes" then the formula in another cell will be executed accordingly, otherwise not.
Is there any formula in excel that will define the function of one cell depend upon the result of another cell. If the result of one cell is "Yes" then the formula in another cell will be executed accordingly, otherwise not.
16 April 2015
Greetings Deepesh,
"IF" function could be one of the options, but that totally depends on the scenario in which you are trying to put it. Also depends the variability of result that will come in the result cell.
Please come up with a situation, may be i could help you with it.
Regards
"IF" function could be one of the options, but that totally depends on the scenario in which you are trying to put it. Also depends the variability of result that will come in the result cell.
Please come up with a situation, may be i could help you with it.
Regards
Message likes :
1 times
16 April 2015
Thank You Vignesh for replying.
I am trying to program the calculation of Penal Interest u/s 234A/B/C in excel. Almost done with it. But when I am trying to automate the Cal. of Interest u/s 234B, not able to do it. The problem is when I check the condition of Total Advance Tax Paid during the year is less than 90% of Assessed tax". If it is "YES" then proceed for next step (i.e. calculation of interest) in another cell. But if it is "NO" then calculation should not be done.
Cell 1------->Cell 2
Cell 1 = Is Total Advance Tax Paid during the year less than 90% of Assessed tax? (Here, i am using "If" formula)
Cell 2 = if cell 1 "YES" then interest should be calculated. / if "No" then no cal should be done. I want to automate this whole process.
I am trying to program the calculation of Penal Interest u/s 234A/B/C in excel. Almost done with it. But when I am trying to automate the Cal. of Interest u/s 234B, not able to do it. The problem is when I check the condition of Total Advance Tax Paid during the year is less than 90% of Assessed tax". If it is "YES" then proceed for next step (i.e. calculation of interest) in another cell. But if it is "NO" then calculation should not be done.
Cell 1------->Cell 2
Cell 1 = Is Total Advance Tax Paid during the year less than 90% of Assessed tax? (Here, i am using "If" formula)
Cell 2 = if cell 1 "YES" then interest should be calculated. / if "No" then no cal should be done. I want to automate this whole process.
16 April 2015
Greetings Deepesh,
Kindly check your pm.. I have got an excel file which i have added to the file section but the same is under moderation. as soon as it is done it will be available . if u r in need then email is the only way. but before that do read reply to ur pm.
Kindly check your pm.. I have got an excel file which i have added to the file section but the same is under moderation. as soon as it is done it will be available . if u r in need then email is the only way. but before that do read reply to ur pm.
17 April 2015
Greeting Vignesh,
I found a working solution. :)
=IF(A1="yes", SUM(A2:A4), "")
Thank you vignesh for your support.
I found a working solution. :)
=IF(A1="yes", SUM(A2:A4), "")
Thank you vignesh for your support.
17 April 2015
Greetings Deepesh,
Well, ur welcome .. :)
I hope ur query is solved so I am closing this thread
Well, ur welcome .. :)
I hope ur query is solved so I am closing this thread
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
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- ITDS U/S.194T of Firm
- Difference between Date of Payment and Date of Deduction?
- Journal entry of busniess expenses
- Cash balance limit and property purchases limit
- NRI starting business in India
- Bank details not Visible on Traces Portal
- TDS ON EMAIL DOMAIN SERVICE BILL
- FCRA 6 E- Intimation
- Invertaded duty struture
- 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
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
