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
- SEC 54 OF IT ACT
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Where to show the RCM on Rent paid to unregistered landlord
- Is Aadhar PAN linking required for opening bank account?
- Form 26QB for TDS on property
- Residential status for filling income tax returns in India
- GST Annual Returns filing due date
- DTCP approval
- Partnership Business Can start India (two partners one is Indian and OCI both are wife and Husband)
- BLOCKED-INELIGIBLE GST CREDIT
- Strategic Performance Management and Business Valuation
- Appeals vs Writ court -certain doubt
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- 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 Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
