Thank you, David.

I tried that and I keep getting the #VALUE! message in that cell. In A22, I
have a calulation from above that is =A14-INT(A14). Basically, I want to
take any partial from line 14, put it on line 22 and then multiply by line 23
and put the total in this cell. Right now, line 22 is 0, so I want the cell
to be blank, but it has #VALUE! instead.

"a3rdcharm" wrote:

I'm trying to create a formula that does the following. Can you help me put
it in the right format?

if E8=X, then G8=G4*m8
and if E* is blank, leave blank