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 Threads
- VRS / Severance Pay full exemption u/s 89 ( 10E fo
- Sponsorship fees GST
- Error in verification of ITR-2
- Form 12aa for Religious and Charitable trust
- Schedule 112A CSV template
- RNOR status and exemption on RFC account interest
- Upload error for ITR 2 filing after validation
- CCI Forum gets fresh Look ! Share your views
- Presumptive taxation 44AD BLOCK PERIOD
- FORM 27Q FILING
Related Threads
CAclubindia
