| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
