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
|