create a formula in excel to prevnt negative
 

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.

Hi

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

Andy.

"neil@snowandjones" wrote in
message ...
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.

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

--
Ian
--
"neil@snowandjones" wrote in
message ...
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.

Sorry! I read your subject and not your post!

Andy.

"neil@snowandjones" wrote in
message ...
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.

Thanx Ian.
Worked a charm
Neil.

"Ian" wrote:

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

--
Ian
--
"neil@snowandjones" wrote in
message ...
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.

No problem. Thanks for the feedback.

--
Ian
--
"neil@snowandjones" wrote in
message ...
Thanx Ian.
Worked a charm
Neil.

"Ian" wrote:

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

--
Ian
--
"neil@snowandjones" wrote
in
message ...
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.