If statement

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

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
 
Do you mean

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically add lines and keep formulas 2
Adding cells but leaving blank if not populated 1
data from 1 sheet to the next 6
Countif/SumProduct 4
Date-time updates every cell? 3
IF Statement (AND/OR) 2
IF function says too many nested 1
sum not working with excel formulas 2

Back
Top