| 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 |
| 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) | |||
Threaded Mode
