LinkBack URL
About LinkBacks
Can anyone help me on how to combine concatenate, if & and functions? I have attached an snapshot of the excel file I am working on. I want to add the if function in selecting if it is After Market Close and Before Market Close.
Can anyone help me on how to combine concatenate, if & and functions? I have attached an snapshot of the excel file I am working on. I want to add the if function in selecting if it is After Market Close and Before Market Close.
Last edited by medlock_1989; 06-29-2013 at 06:44 PM. Reason: will attach new file
Can you post the results you want to happen for the before/after market close situations?
Thanks for the reply! I will be attaching the excel sheet as adviced by martindwilson..
I have attached the excel file..In my formula I manually added AMC but I want it to be automated. Column D has After Market Close and Before Market CLose. I want to incorporate that into my formula whereas if it is After Market Close, then it will be AMC and if it is Before Market Close, then it is BMO..Originally Posted by Ron Coderre
please Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for the heads up! I will attach the excel file..
Hi Martin! I have already attached the excel file..
Using your posted workbook....
this regular formula inserts the appropriate acronyms:
Formula:
G3: ="$ "&B3&" Earnings out "&INDEX({"AMC","BMO","TNS"},MATCH(D3,{"After Market Close","Before Market Open","Time Not Supplied"},0))&", EPS estimate "&C3
Is that something you can work with?
Wow! Thank you very much Ron! You are such a great help..My problem has been solved thanks to you!Using your posted workbook....
this regular formula inserts the appropriate acronyms:
Formula:G3: ="$ "&B3&" Earnings out "&INDEX({"AMC","BMO","TNS"},MATCH(D3,{"After Market Close","Before Market Open","Time Not Supplied"},0))&", EPS estimate "&C3
Is that something you can work with?
Your very welcome...I'm glad I could help.
Another question, I don't know if this is allowed but I have used the formula in google spreadsheet but it doesn't work there..using the formula you have given, the result was triplicated if used in Google Spreadsheet.
Is Google spreadsheet compatible with Excel? Google spreadsheet probably has its own functions and function syntax and may not be compatible with the functions used in Excel.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks