create a formula in excel to prevnt negative

[Guest]

here is my formula to show in cell E4 =(A4*0.02)+((C4-A4)*0.03)
However, i do not want to calculation made if the value of C4 is less than
the value of A4.
For the purposes of this result, this will make an invalid result.

 

[Guest]

Hi

Try this:
=MAX((A4*0.02)+((C4-A4)*0.03),0)

Andy.

 

[Ian]

=IF(C4<A4,"",(A4*0.02)+((C4-A4)*0.03))

 

[Guest]

Sorry! I read your subject and not your post!

Andy.

 

[Guest]

Thanx Ian.
Worked a charm
Neil.

=IF(C4<A4,"",(A4*0.02)+((C4-A4)*0.03))

 

[Ian]

No problem. Thanks for the feedback.

--
Ian
--

Thanx Ian.
Worked a charm
Neil.