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 in Excel sidebar, click Settings.

  2. Open the View advanced settings dropdown.

  3. Set the values of:

    • Top P: from 0 to 1.

      Use the slider or the text field to input a value
      note

      Set the temperature parameter to 1 when the value for Top P is lower than 1.

    • Frequency penalty: from 0 to 2.

      Use the slider or the text field to input a value

    • Presence penalty: from 0 to 2.

      Use the slider or the text field to input a value

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.