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

Try this:

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

Hope this helps.

Pete

On Dec 5, 3:38*pm, Jamie wrote:
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

Maybe

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

Mike

"Jamie" wrote:

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

Have you looked in the help index for

IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

=IF(LEFT(C2,2)="US",F4*H3,"")
--
Gary''s Student - gsnu200817

Mike,

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

"Mike H" wrote:

Maybe

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

Mike

"Jamie" wrote:

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

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

On Dec 5, 4:28*pm, Jamie wrote:
Mike,

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



"Mike H" wrote:
Maybe

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

Mike

"Jamie" wrote:

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- Hide quoted text -

- Show quoted text -

Have you looked in the help index for

LEFT
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jamie" wrote in message
...
Mike,

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

"Mike H" wrote:

Maybe

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

Mike

"Jamie" wrote:

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

It does, thanks Pete!

"Pete_UK" wrote:

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

On Dec 5, 4:28 pm, Jamie wrote:
Mike,

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



"Mike H" wrote:
Maybe

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

Mike

"Jamie" wrote:

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- Hide quoted text -

- Show quoted text -

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

Pete

On Dec 5, 5:22*pm, Jamie wrote:
It does, thanks Pete!