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.
|