How to calculate "IF"

[RatHat]

I have a problem trying to make a calculation based on the whether a cell contains a certain value. The easiest way to explain it would be by showing my problem:

	A	B	C	D	E
1	QTY	Currency	Unit	Total	Total USD
2	2	SGD	2,500.00	5,000.00
3	2	USD	1,000.00	2,000.00	2,000.00
4	1 SGD =	0.790936

So, my problem is IF I want cell E2 to check to see whether cell B2 contains the value SGD, then to multiply cell D2 by the exchange rate shown in cell B4. IF it contains the value USD though, to equal the value of D2.

How do I do this?

Any help much appreciated as I am beginning to look like Yul Brynner!

[Pete_UK]

Put this in E2:

=IF(B2="SGD",B$4,1)*D2

Hope this helps.

Pete

[RatHat]

What a beauty!

Thank you very much Pete_UK!

[Pete_UK]

Thanks for feeding back.

You can mark the thread as Solved by clicking on the Thread Tools button above your first post.

Pete

[Lili Robinson]

Good one, hope to refer to for myself