Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing the value of a cell if another cell equals a set value
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing the value of a cell if another cell equals a set value
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing the value of a cell if another cell equals a set value
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 mg_sv_r wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing the value of a cell if another cell equals a set value
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". "mg_sv_r" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions |