Skip to main content

Adjust advanced settings

Adjust the advanced settings to have better control over generated output in Microsoft Excel. You can learn more in the OpenAI API documentation.

SettingsDescription
Top PHelps adjust creativity level - Lower values result in more focused output, while higher values allow for more creative responses.
Note: Set the temperature parameter to 1 when using Top P.
Frequency penaltyPenalizes tokens based on their frequency in the training data - Higher values encourage less repetitive words or phrases.
Presence penaltyPenalizes new tokens based on how often they have occurred in the input - Higher values discourage repetition.
  1. In the GPT for Excel sidebar, click Settings.

    The Behavior bar allows you to select an action and type a prompt.
  2. Open the View advanced settings dropdown.

  3. Set the values of:

    • Top P: from 0 to 1.
    The default level is set to 1 by default.
    • Frequency penalty: from 0 to 2.

      The Frequency penalty is set to 0 by default.
    • Presence penalty: from 0 to 2.

    The default level is set to 0 by default.

You can now execute a GPT function in the current workbook with these advanced settings.

What's next

Refresh your GPT formulas to get results that take these new settings into account.