Thread: formula help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Titanium
 
Posts: n/a
Default formula help

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