How to get one value from 2 different cells

[Iraj]

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.

[ArviLaanemets]

Your range references seem off somehow! I assume datarange starts from row 6:
for P6

=IF(AND(F6="Y",L6="N"),E6,IF(AND(F6="N",L6="Y"),-1*K6,""))

for O6

=IF(AND(F6="Y",L6="N"),"",IF(AND(F6="N",L6="Y"),"",E6-K6))

[Iraj]

Hi,

Perfectly worked thanks for your prompt response sir.

Sincerely Iraj