Using floor was a good idea. I knew there was a function like that, but
didn't remember which one it was. It was just quicker to multiply by 100 and
use INT. Sometimes it pay just to do things the quick way than the right
way. In this case, looking up the function name would of taken time.

"nastech" wrote:

this seems to work:
=IF(AND(H17="",OR(OFFSET(I17,-1,0)="",$I$7="",$I$8="")),"",FLOOR(IF(H17="x",$I$7 ,OFFSET(I17,-1,0)+$I$8),$I$8))

"nastech" wrote:

I'm going to guesse: use of OFFSET()
will repost with answer. thanks