Excel formula???
This query is : Resolved
CA Deepesh Ruhela
(Querist)
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
CA Deepesh Ruhela
(Querist)
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.
CA Deepesh Ruhela
(Querist)
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
- Gst credit note by supplier
- Movement of goods by packers and movers - type of sale - Reg.
- GST on reimbursement of expenses
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Missed uploading GST Invoice
- Query on effect of registration of property
- Gratuity paid to legal heir above 20 lakh is taxable or not
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Goodwill transfer of deceased father’s firm – ICAI applying a 27.04.2026 cut-off to the 3 year limit
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
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
