If statement

Annette · Jul 14, 2005

I'm trying to write a statement that says if cell b5 contains
04.****.***.***, then take the number found in cell g5 times the number in
H5 but it is not functioning. Just providing a zero.

Thanks!

Annette

Bob Phillips · Jul 14, 2005

Do you mean

=IF(LEFT(B5,3)="04.",g5*h5,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)

Annette · Jul 14, 2005

Ah ... thank you!

Bob Phillips said:
Do you mean

=IF(LEFT(B5,3)="04.",g5*h5,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)