Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
What I need to achive in cell B1 is: if A3 = "pippo" then value*exchange rate, "", otherwise leave it blank In A3 there is Vlookup returning a name. As I said depending on the name I need the if function in B1 to multiply the value by the exchange rate - USD to EURO Problem A3 contains a Vlookup and it does not return the name to the cell B1 that contains the IF function therefore I am not able to establish if the formula can or cannot convert the value from USD into EURO - B1 is returning only true or false but not the name in A3 - The name (pippo) in B1 is what I need. Hope you can help - Thank you - Arno |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOUP | Excel Discussion (Misc queries) | |||
VLOOUP | Excel Programming | |||
vlooup with an if statement????? | Excel Worksheet Functions | |||
vlooup formula and if(),isna etc | Excel Worksheet Functions | |||
Linking cells (VLOOUP/IF function maybe?) | Setting up and Configuration of Excel |