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 :
- GSTR1 amendment Bulk bills
- Capital Gain on Sale of Gold
- GST SALES RETURN MISSING 2025-26 FY
- Enquiry on FAST-DS system generated email
- Capital gain on sale of agriculture land
- Demand from TRACES
- FY 2025-26 ITC CLAIM DUE DATE
- 96084000 and 48202000 HSN code ka Tax Rate kya hai
- Clarifications for intra day transactions
- CA FINAL FR FINANCIAL INSTRUMENTS (Ind AS 109) Dou
Related Topics :
CAclubindia
