Execute Excel Formula with Powershell This topic contains 1 reply, has 2 voices, and was last updated by daniel 2 weeks, 6 days ago. Author Posts June 27, 2018 at 1:05 am #103423 HilParticipant I can execute the following formula in Excel and it gets the last price of IBM =RTD("tos.rtd", , "LAST", "IBM") How can execute something similar using PowerShell ? (The above formula was taken from https://www.stock-data-solutions.com/realtimetodb/rtd-database-quotes-tos-rtd.htm ) Thanks Hil June 28, 2018 at 12:34 pm #103513 danielParticipant well, I can suggest you that you should follow these things: Most of the time in excel to find how many "string" is used in a row we use =NB.SI(range,"string"). I would like to call this function (=NB.SI(range," string") ) with a PowerShell script. I tried to use$objExcel.worksheetFunction.Match("string",range) but it wasn't useful. Author Posts You must be logged in to reply to this topic.