Forum Discussion

lin123's avatar
lin123
Copper Contributor
Nov 29, 2024

Help needed with calculated column

I am trying to add a calculated column in Microsoft Lists that follows this logic: If the value in Column A is equal to "Yes," the calculated column should take the value from Column B and subtract...
Lists
Rob_Elliott's avatar
Rob_Elliott
Silver Contributor
Nov 30, 2024

I had no issues with =IF(Adjust="Yes",InStock-16,"")

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

  • Sigi7's avatar
    Sigi7
    Brass Contributor
    Dec 01, 2024

    Rob_Elliott 

    odd, I would have thought that the comparison operator has to be "==" !?

    BR, Sigi