Excel formula help

[JunaidZahoor1985]

If d4="yes" and e4 >=c4
Then show e4 else -(e4)
Or
If d4="no" and r4<c4
Then show e4 else -(e4)

 

[herofox]

please upload the file ?!!!!!

 

[AlanSidman]

=if(and(D4="yes",E4>=C4),E4,-E4)