One more final tweak...

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

Modify the formula to:

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

M. Stanley wrote:
> How do I further modify it so that if G17<H17 it also equals zero?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra!

"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:41E73434.8090205@contexturesXSPAM.com...
> Modify the formula to:
>
> =IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5)
>
> M. Stanley wrote:
>> How do I further modify it so that if G17<H17 it also equals zero?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

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


"M. Stanley" <superstan76@hotmail.com> wrote in message
news:%23Ol4aSl%23EHA.3416@TK2MSFTNGP09.phx.gbl...
> Thanks Debra!
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> news:41E73434.8090205@contexturesXSPAM.com...
>> Modify the formula to:
>>
>> =IF(OR(H17=0,G17-H17<=0),0,(G17-H17)*1.5)
>>
>> M. Stanley wrote:
>>> How do I further modify it so that if G17<H17 it also equals zero?
>>
>>
>> --
>> Debra Dalgleish
>> Excel FAQ, Tips & Book List
>> http://www.contextures.com/tiptech.html
>>
>
>