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 Topics :
- Report in GSTR 1 ( Credit Note ) for Wrong GST Rat
- Reply of summons issued under section 70 of the cg
- How to Bulk GSTIN Number Verify and Validation
- OPC Annual Filing Defaults – Need Guidance t
- OPC Annual Filing Defaults – Need Guidance t
- FCGPR of a past period
- Discuss and Download CA Final Question Paper Nov 2
- Does Parag gupta's booster batch good for CA Inter
- Police Bandobost and GST Invoice
- Understanding where manual effort goes in audit wo
Related Topics :
CAclubindia
