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
- About TDS & Income Tax
- Scrutiny and reopening of past returns
- Tax on Deemed Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Exiting partner in partnership firm in gst portal
- Type of Capital Gain
- Booth for sales promotion
- Regarding ITR filing with more value than showing in AIS/TIS
- LIABILITY ADJUSTMENT
- IT returns for fresh job holders
- Housing Society-ITR5
- NRI INSURANCE ADVISOR
- 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
