hi 1st time user here
i have spreadsheet for all the products i purchase. i buy in 3 different currencies $, Euro & £. i have 3 separate columns (f, g & H) for the 3 different currencies and only 1 of them is supposed to be populated with the relevant cost price e.g. cell F5 will say $2.50 or cell G5 Euro5.00 etc.
at the top of each of these columns i have the exchange rate for each of the currencies (f2, g2 & h2)
In column "I" i need it to say the exchange rate for that product however i need a formula to select the correct exchange rate based on which field in the buying price columns is populated. would also be helpful if an error message would generate if 2 buying fields were populated.
hope i've been clear enough and hoping someone can help me.
i have spreadsheet for all the products i purchase. i buy in 3 different currencies $, Euro & £. i have 3 separate columns (f, g & H) for the 3 different currencies and only 1 of them is supposed to be populated with the relevant cost price e.g. cell F5 will say $2.50 or cell G5 Euro5.00 etc.
at the top of each of these columns i have the exchange rate for each of the currencies (f2, g2 & h2)
In column "I" i need it to say the exchange rate for that product however i need a formula to select the correct exchange rate based on which field in the buying price columns is populated. would also be helpful if an error message would generate if 2 buying fields were populated.
hope i've been clear enough and hoping someone can help me.