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
- ITC availment relationship
- Challan confusion in ITR B block return
- U/s 23 (2)(a) and 23 (2)(b)
- Building a Strong Financial Foundation: Key Accoun
- Long Term Capital Gains for shares
- Hiring Company Secretary Manager with 2 Years of P
- Updated Return _ Deduction
- Turf Club Veterinary Department. Procurement Manua
- I have wrongly shown itc in reclaimable itc inste
- Help reqd in getting Professional Tax challan
Related Threads
CAclubindia
