One more final tweak...

[M. Stanley]

How do I further modify it so that if G17<H17 it also equals zero?

 

[Debra Dalgleish]

Modify the formula to:

=IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5)

 

[M. Stanley]

Thanks Debra!

Modify the formula to:

=IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5)

 

[Dana DeLouis]

What you have is better, but something I was experimenting with suggested
the following:

=(3*(G17-H17)/2)*(G17>H17)*(H17<>0)

Hope this came out right.
--
Dana DeLouis
Win XP & Office 2003

Thanks Debra!