Skip to content

Instantly share code, notes, and snippets.

@ExcelRobot

ExcelRobot/CompatibilityVersion.lambda

Last active December 9, 2024 01:44
Show Gist options
  • Save ExcelRobot/493c72fa9cd68be6e833e6da772c9047 to your computer and use it in GitHub Desktop.
Save ExcelRobot/493c72fa9cd68be6e833e6da772c9047 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Calculation Compatibility Version
Raw
CompatibilityVersion.lambda
/*
Name: Compatibility Version (CompatibilityVersion)
Description: Returns whether Excel calculation is in compatibility version 1 or 2.
Source: @ExcelRobot
*/
CompatibilityVersion =LAMBDA(IF(LEN("🤖") = 2, 1, 2));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment