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.
Menu
Excel formula?
Replies (2)
Suppose Cell A1, B1 and C1 contains 10, 20 and 30 respectively.
.
YES/NO result comes in cell D1.
.
Now in E1, you can use the IF function, as below:
.
=IF(D1="YES",SUM(A1:C1),"N.A.")
.
Now, if D1 is YES, E1 will show the result as 60, otherwise N.A.
Thank you so much for explaining the absolute and relative cell references.
Recent Topic
- Is CA through direct entry easy for a commerce stu
- Dividend and withholding tax - DTAA- RSU
- NRI Query: Capital Gains Tax Exemption under Secti
- Royalty payment to UK
- Calculate ITR2 tax with equity and non equity prof
- LTCG on residential property sale - Rebate?
- TDS MISMATCH AND AIS
- Return filing for intervening period upto date of
- EPF Withdrawal taxation
- While e filing otp not generating
Related Topics
CAclubindia
