How to get one value from 2 different cells
Please help;
Please give a formula that can choose from 2 different cells just one value.
1- I want to have a formula in P2, P3, and so on, when F2 cell is Y the amount from cell E2 shows in P2 cell. But when L2 is Y, then P2 Turns Blank and differences ofE2 & K2 cells shows in O2.
2- Another condition for P2, if now F2 is N, but L2 is Y the same P2 shows K2 Value with negative sign example here(-250), and later when F2 cell is turns to Y, P2 becomes blank again and differences of E2 & K2 cells shows in O2.
Please any idea, check the attached sheet and instruct.
Thanks.
Iraj.
|