IF function to get a (specific) name from a Vlookup and convert va
 

A3 (Vlookup) returns a name, depending on which name I need the if function
in a cell to multiply the value by the exchange rate - USD to EURO

Problem
A3 contains a Vlookup and it does not return the name that I need to
establish if the formula can or cannot convert the value from USD into EURO

Example:
A3=pippo
B1 if A3="pippo",B1*0.78 ...instead I get 0 or FALSE....

Can anybody assist - Thanks Arno

IF function to get a (specific) name from a Vlookup and convert va
 

Arno,

You need to fill in the false aspect of your tertiery function.

=If(A3="pippo",true,false)

You left out the false part
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Arno" wrote:

A3 (Vlookup) returns a name, depending on which name I need the if function
in a cell to multiply the value by the exchange rate - USD to EURO

Problem
A3 contains a Vlookup and it does not return the name that I need to
establish if the formula can or cannot convert the value from USD into EURO

Example:
A3=pippo
B1 if A3="pippo",B1*0.78 ...instead I get 0 or FALSE....

Can anybody assist - Thanks Arno