View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default This will be really easy, I'm sure

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