This will be really easy, I'm sure

[Jamie]

Hi there,
I'm sure this will be really easy for you all. I want to multiply, for
example, the conents of 2 cells, when a third cell has the initials US in it.

I.e. if the freight is going to anywhere in the US(mentioned in cell c2), it
multiplies kilos (cell f4) by a per kilo rate (cell h3). if c2 does not start
with US, it leaves the cell blank.

Thanks in advance for your help.

Jamie

 

[Pete_UK]

Try this:

=IF(LEFT(C2,2)="US",F4*H3,"")

Hope this helps.

Pete

 

[Mike H]

Maybe

=IF(LEFT(C2,2)="US",F4*H3,"")

Mike

 

[Don Guillett]

Have you looked in the help index for

IF

 

[Gary''s Student]

=IF(LEFT(C2,2)="US",F4*H3,"")

 

[Jamie]

Mike,

Thanks for this, quick question, why the 2, in (c2,2)?

 

[Pete_UK]

You want to see if the first 2 letters in C2 are equal to "US" - not
bothered if there are more letters, eg "US California".

Hope this helps.

Pete

 

[Don Guillett]

Have you looked in the help index for

LEFT

 

[Jamie]

It does, thanks Pete!

You want to see if the first 2 letters in C2 are equal to "US" - not
bothered if there are more letters, eg "US California".

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Jamie - thanks for feeding back.

Pete