Help with Power Agents Custom Functions
It is possible to enter Power Agents custom function formulas directly into cells. The
prompt field and 'Place Formula' button make this easier for you as it automatically chooses
the correct function for you based on the number of elements in your prompt. But but if you
would like to enter formulas directly into cells or adjust formulas already placed in the
cells, you can follow the instructions and examples below:
ONE function
The ONE function allows you to make a simple request to an AI model. This function uses a
single sentence question with no cell target values as part of the input.
Example Formula:
=agent.one("oai4o", "Is a hotdog a sandwich?")
In this formula, "oai4o" is the model ID and "Is a hotdog a sandwich?" is the question for the
AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TWO function
The TWO function allows you to make a request of an AI model with two elements. An example of
a formula using this function is shown below:
Example Formula:
=agent.two("oai4o", "Provide a short summary of the following product:", B2)
In this case, cells in the B column could be populated with different product names.
In this formula, "oai4o" is the model ID and ("Provide a short summary of the following
product: ", B2) is the question for the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
THREE function
The THREE function allows you to make a request of an AI model with three elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.three("oai4o", "Is a ", B2, " a sandwich?)
In this formula, "oai4o" is the model ID and "Is a, B2, "a sandwich?" is the question for the
AI model - where B2 can be replaced by values in the B column such as "hamburger", "hoagie",
or "taco".
For a list of all of the model ID codes that you can use with this function, refer to this
table.
FOUR function
The FOUR function allows you to make a request of an AI model with four elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.four("oai4o", "Evaluate the product ", B2, " on it's ", C2)
In this formula, "oai4o" is the model ID and the four elements that follow this could
concatenate values to create a question like "Evaluate the product iPhone 16
on it's battery life".
For a list of all of the model ID codes that you can use with this function, refer to this
table.
FIVE function
The FIVE function allows you to make a request of an AI model with five elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.five("oai4o", “Compare the performance of these two products: “, B2, "and", C2, "for budget smart phone customers.")
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
SIX function
The SIX function allows you to make a request of an AI model with six elements. An example of
a formula using this function is shown below:
Example Formula:
=agent.six("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“and a P/E ratio of “, C2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
SEVEN function
The SEVEN function allows you to make a request of an AI model with seven elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.seven("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“and a P/E ratio of “, C2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
EIGHT function
The EIGHT function allows you to make a request of an AI model with eight elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.eight("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“and an EPS of “, D2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
NINE function
The NINE function allows you to make a request of an AI model with nine elements. An example
of a formula using this function is shown below:
Example Formula:
=agent.nine("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“and an EPS of “, D2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TEN function
The TEN function allows you to make a request of an AI model with ten elements. An example of
a formula using this function is shown below:
Example Formula:
=agent.ten("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“and a Net Profit Margin of “, E2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
ELEVEN function
The ELEVEN function allows you to make a request of an AI model with eleven elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.eleven("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“and an EPS of “, D2,
“and a Net Profit Margin of “, E2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TWELVE function
The TWELVE function allows you to make a request of an AI model with twelve elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.twelve("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“and a Net Profit Margin of “, E2,
“and a Market Cap of “, F2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
THIRTEEN function
The THIRTEEN function allows you to make a request of an AI model with thirteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.thirteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“and a Market Cap of “, F2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
FOURTEEN function
The FOURTEEN function allows you to make a request of an AI model with fourteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.fourteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“and a Debt to Equity Ratio of “, G2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
FIFTEEN function
The FIFTEEN function allows you to make a request of an AI model with fifteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.fifteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“and a Debt to Equity Ratio of “, G2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
SIXTEEN function
The SIXTEEN function allows you to make a request of an AI model with sixteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.sixteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“and a Revenue Growth Last Year of “, H2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
SEVENTEEN function
The SEVENTEEN function allows you to make a request of an AI model with seventeen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.seventeen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“and a Revenue Growth Last Year of “, H2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
EIGHTEEN function
The EIGHTEEN function allows you to make a request of an AI model with eighteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.eighteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“a Revenue Growth Last Year of “, H2,
“and a Return on Equity of “, I2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
NINETEEN function
The NINETEEN function allows you to make a request of an AI model with nineteen elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.nineteen("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“a Revenue Growth Last Year of “, H2,
“a Return on Equity of “, I2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TWENTY function
The TWENTY function allows you to make a request of an AI model with twenty elements. An
example of a formula using this function is shown below:
Example Formula:
=agent.twenty("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“a Revenue Growth Last Year of “, H2,
“a Return on Equity of “, I2,
“and a Cash Flow of “, J2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TWENTYONE function
The TWENTYONE function allows you to make a request of an AI model with twenty one elements.
An example of a formula using this function is shown below:
Example Formula:
=agent.twentyone("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“a Revenue Growth Last Year of “, H2,
“a Return on Equity of “, I2,
“a Cash Flow of “, J2,
“. Please provide a yes or no answer followed by an explanation of your analysis.“
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
TWENTYTWO function
The TWENTYTWO function allows you to make a request of an AI model with twenty two elements.
An example of a formula using this function is shown below:
Example Formula:
=agent.twentytwo("oai4o", “Is it a good time to invest in “, A2,
“considering its current price of $”, B2,
“a P/E ratio of “, C2,
“an EPS of “, D2,
“a Net Profit Margin of “, E2,
“a Market Cap of “, F2,
“a Debt to Equity Ratio of “, G2,
“a Revenue Growth Last Year of “, H2,
“a Return on Equity of “, I2,
“a Cash Flow of “, J2,
“and a Sector Performance of “, K2,
In this formula, "oai4o" is the model ID and each of the elements separated by commas are
indivdiual parts of the request which will be concatenated together and sent to the AI model.
For a list of all of the model ID codes that you can use with this function, refer to this
table.
This table provides the mapping between model ID codes, the providers, and the full model names
for each model.
| Model ID | API Endpoint | Long-form Model Name |
|---|---|---|
| oai4o | OpenAI | gpt-4o |
| oai4om | OpenAI | gpt-4o-mini |
| oai4t | OpenAI | gpt-4-turbo |
| oai4 | OpenAI | gpt-4 |
| oai35t | OpenAI | gpt-3.5-turbo |
| pplxs | Perplexity | llama-3.1-sonar-small-128k-online |
| pplxl | Perplexity | llama-3.1-sonar-large-128k-online |
| pplxh | Perplexity | llama-3.1-sonar-huge-128k-online |
| cla35s | Anthropic | claude-3-5-sonnet-20240620 |
| cla3o | Anthropic | claude-3-opus-20240229 |
| cla3s | Anthropic | claude-3-sonnet-20240229 |
| cla3h | Anthropic | claude-3-haiku-20240307 |
| gem15p | gemini-1.5-pro-latest | |
| gem15f | gemini-1.5-flash-latest |