Simple Formula Needed, Please!

[CM]

Hi All,

I have a simple spreadsheet that calculates market gains and losses.

I want to add a column to my spreadsheet that will convert a stock price to
Can $ from US $, if "US" is entered in the cell next to the price.

Make sense?

Thanks in advance!

CM

 

[Norman Harker]

Hi CM!

Try something like:

=IF(D50="US",C50*J1,"")

J1 is the home of your conversion rate.

But if J1 changes it will change all previous conversions. So you may
prefer:

=IF(D50="US",C50*H50,"")

Here H50 is the conversion fact that applies to just this transaction.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.