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.

Attached Files

GS Customer sheet.xlsx (210.1 KB, 9 views)