multiply with - if text

[potzo]

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?

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[potzo]

[potzo]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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

Please Login or Register  to view this content.

Thanks a lot!!!