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.
CA Deepesh Ruhela (Keen to Learn) (3271 Points)
16 April 2015Hi,
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.
Deepak Gupta
(CA Student)
(15922 Points)
Replied 16 April 2015
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.
CA Deepesh Ruhela
(Keen to Learn)
(3271 Points)
Replied 17 April 2015
Thank you so much for explaining the absolute and relative cell references.