Forum Discussion
Solved
Excel - How to automate a cell so it contains one of two formulas, depending on the situation
I'm an Excel neophyte and would appreciate any guidance the community can provide! I need the formula in each cell of Column D to be situational. (Screenshot below of selected columns) In o...
=IF(A60="Y", ABS(F60+G60),E60+F60)
You can try this formula in cell D60. Y is text and has to be entered in "" within a formula.
=IF(A60="Y", ABS(F60+G60),E60+F60)
You can try this formula in cell D60. Y is text and has to be entered in "" within a formula.
Quadruple Pawn, you've done it again! Thanks!!