Dividing the value of a cell if another cell equals a set value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi again,

Need help with another formula, I have the following table.

A B C D
1 19.00 GBP fred
2 27.00 EUR BOB
3 56.90 CAD Bill

I want a mathmatical function to multiply the value in column A by say 0.74
if the value in column B = "EUR" and enter the result in column D.

Thanks again for any help. It really is much appreciated.

John
 
John,
if you want column D:D to remain blank for non EUR currencies, then use
this formula:
=IF(B2="EUR", A2*0.74, "")

HTH
Kostis Vezerides
 
Hi John

One way, use a LOOKUP formula
=A2*LOOKUP(B2,{"CAD","EUR","GBP";0.498,0.74,1})
Copy down column C as far as required.
Change the rates to suit.

Regards

Roger Govier
 
This would be the formula for cell "D1"

=if(b1="EUR",A1*.74,"")

If the value in "B1" is "EUR", then "A1" times .74 will appear in "D1". If
"B1" is not "EUR", then nothing will appear in "D1".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Match a currency with its corresponding value 4
If a cell equals another cell, then use the value in the cell to theright. 2
If statement for equivalent value of a range 4
calculating values depending on columns in different wkbooks. 2
Vlookup for part Lookup_value 4
See if cell value appears within a value range given by another cell. 9
return the Cell address of a value 3

Back
Top