ExcelBanter - If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If statement (https://www.excelbanter.com/excel-worksheet-functions/35427-if-statement.html)

Annette

If statement

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

Do you mean

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

--

HTH

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

"Annette" wrote in message
...
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

Annette

Ah ... thank you!

"Bob Phillips" wrote in message
...
Do you mean

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

--

HTH

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

"Annette" wrote in message
...
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

All times are GMT +1. The time now is 02:33 AM.