View Single Post
  #2   Report Post  
 
Posts: n/a
Default

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.