software

I have column E which is showing the curency - quot;$quot; and quot;€quot;
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: www.excelforum.com/member.php...oamp;userid=33901
View this thread: www.excelforum.com/showthread...hreadid=537998It seems to me that you want

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;potzoquot; gt; wrote in message
news
gt;
gt; I have column E which is showing the curency - quot;$quot; and quot;?quot;
gt; Column F is indicating the value in whichever curency is indicating E
gt; J3 contains the value of a dollar
gt; I3 contains the value of an euro
gt; I want -cell C3 multiplied with E3 if the text in E3 is $ or multiplied
gt; with i3 if text in E3 is ?
gt; or.... -cell C3 multiplied with E3 if the text in E3 is $ or
gt; multiplied with i3 if text in E3 is not $
gt;
gt; whichever is easier
gt;
gt; Can anybody helpme with this, pls?
gt;
gt;
gt; --
gt; potzo
gt; ------------------------------------------------------------------------
gt; potzo's Profile:
www.excelforum.com/member.php...oamp;userid=33901
gt; View this thread: www.excelforum.com/showthread...hreadid=537998
gt;

it works after i strggled a little bit
=IF(E3=quot;$quot;;F3*J2;IF(E3=quot;?quot;;F3*I2)--
potzo
------------------------------------------------------------------------
potzo's Profile: www.excelforum.com/member.php...oamp;userid=33901
View this thread: www.excelforum.com/showthread...hreadid=537998
Bob Phillips Wrote:
gt; It seems to me that you want
gt;
gt; =IF(E3=quot;$quot;,C3*J3,IF(E3=quot;?quot;,C3*I3,quot;quot;))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;potzoquot; gt; wrote in
gt; message
gt; news
gt; gt;
gt; gt; I have column E which is showing the curency - quot;$quot; and quot;?quot;
gt; gt; Column F is indicating the value in whichever curency is indicating
gt; E
gt; gt; J3 contains the value of a dollar
gt; gt; I3 contains the value of an euro
gt; gt; I want -cell C3 multiplied with E3 if the text in E3 is $ or
gt; multiplied
gt; gt; with i3 if text in E3 is ?
gt; gt; or.... -cell C3 multiplied with E3 if the text in E3 is $ or
gt; gt; multiplied with i3 if text in E3 is not $
gt; gt;
gt; gt; whichever is easier
gt; gt;
gt; gt; Can anybody helpme with this, pls?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; potzo
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; potzo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33901
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=537998
gt; gt;
It works like this

Code:
--------------------
=IF(E3=quot;$quot;;F3*J2;IF(E3=quot;?quot;;F3*I2)
--------------------Thanks a lot!!!--
potzo
------------------------------------------------------------------------
potzo's Profile: www.excelforum.com/member.php...oamp;userid=33901
View this thread: www.excelforum.com/showthread...hreadid=537998