multiply with - if text
 

I have column E which is showing the curency - "$" and "€"
Column F is indicating the value in whichever curency is indicating E
J3 contains the value of a dollar
I3 contains the value of an euro
I want -cell C3 multiplied with E3 if the text in E3 is $ or multiplied
with i3 if text in E3 is €
or.... -cell C3 multiplied with E3 if the text in E3 is $ or
multiplied with i3 if text in E3 is not $

whichever is easier

Can anybody helpme with this, pls?


--
potzo
------------------------------------------------------------------------
potzo's Profile: http://www.excelforum.com/member.php...o&userid=33901
View this thread: http://www.excelforum.com/showthread...hreadid=537998

multiply with - if text
 

It seems to me that you want

=IF(E3="$",C3*J3,IF(E3="?",C3*I3,""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"potzo" wrote in message
...

I have column E which is showing the curency - "$" and "?"
Column F is indicating the value in whichever curency is indicating E
J3 contains the value of a dollar
I3 contains the value of an euro
I want -cell C3 multiplied with E3 if the text in E3 is $ or multiplied
with i3 if text in E3 is ?
or.... -cell C3 multiplied with E3 if the text in E3 is $ or
multiplied with i3 if text in E3 is not $

whichever is easier

Can anybody helpme with this, pls?


--
potzo
------------------------------------------------------------------------
potzo's Profile:
http://www.excelforum.com/member.php...o&userid=33901
View this thread: http://www.excelforum.com/showthread...hreadid=537998

multiply with - if text
 

it works after i strggled a little bit
=IF(E3="$";F3*J2;IF(E3="?";F3*I2;))


--
potzo
------------------------------------------------------------------------
potzo's Profile: http://www.excelforum.com/member.php...o&userid=33901
View this thread: http://www.excelforum.com/showthread...hreadid=537998

multiply with - if text
 

Bob Phillips Wrote:
It seems to me that you want

=IF(E3="$",C3*J3,IF(E3="?",C3*I3,""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"potzo" wrote in
message
...

I have column E which is showing the curency - "$" and "?"
Column F is indicating the value in whichever curency is indicating
E
J3 contains the value of a dollar
I3 contains the value of an euro
I want -cell C3 multiplied with E3 if the text in E3 is $ or
multiplied
with i3 if text in E3 is ?
or.... -cell C3 multiplied with E3 if the text in E3 is $ or
multiplied with i3 if text in E3 is not $

whichever is easier

Can anybody helpme with this, pls?


--
potzo

------------------------------------------------------------------------
potzo's Profile:
http://www.excelforum.com/member.php...o&userid=33901
View this thread:
http://www.excelforum.com/showthread...hreadid=537998




It works like this

Code:
--------------------
=IF(E3="$";F3*J2;IF(E3="?";F3*I2;))
--------------------


Thanks a lot!!!


--
potzo
------------------------------------------------------------------------
potzo's Profile: http://www.excelforum.com/member.php...o&userid=33901
View this thread: http://www.excelforum.com/showthread...hreadid=537998