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
- Input tax credit under igst under insurance compan
- ITR Form to be used
- CGAS account Holder Deceased
- ITR form suggestion
- Post office KVP income.
- Free GST invoice tool I built for my practice R
- Clarification on Gratuity Exemption under Section
- GOODS AND SERVICE TAX - GSTR 1
- Correct ITR form
- Clarification required on Section 393 & Report
Related Topics
CAclubindia
