Replacing a formula value if it is negative with another cell value

[Matt_Straya]

Hi,
I have this formula

=IFERROR((C3-D3)/B3,0)*E3

that may result in a negative number ($). If it does I want to display the value in B3.

Grateful for any ideas

 

[GraH - Guido]

Quick and dirty, perhaps this one
=IF(IFERROR((C3-D3)/B3,0)*E3<0,B3, IFERROR((C3-D3)/B3,0)*E3)

But I don't like it very much. I'm sure there is a more elegant one possible. Can't look at your data for the moment to evaluate it.

 

[GraH - Guido]

Not a lot of data in your file.
=IF((C3-D3)/B3*E3<0,B3,IFERROR((C3-D3)/B3*E3,0)

 

[bosco_yip]

Or,

=IF(D3>C3,B3,IFERROR((C3-D3)/B3,0)*E3)

Regards
Bosco

 

[GraH - Guido]

or?
=IFERROR(IF(D3>C3,B3,(C3-D3)/B3*E3),0)

 

[Matt_Straya]

Thanks guys! brilliant! Both seem to work