Worked perfectly thanks!! :)
=IF(H1=0,0,IF((C1-B1)H1,H1,(B1+H1)-B1))

Hi. Just two cents. Note that ",(B1+H1)-B1" reduces to just H1.
Therefore, the answer is H1 no matter what C1-B1 is.
Looks to me that the above equation could be reduced to:
=IF(H1=0,0,H1)
but could be reduced further to just:
=H1.

Hope I understood this correctly.
--
Dana DeLouis
Win XP & Office 2003


"Titanium" wrote in message
...
Worked perfectly thanks!! :)

"Vito" wrote:


Try:


=IF(H1=0,0,IF((C1-B1)H1,H1,(B1+H1)-B1))


--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=488549