Forum Discussion
Checkbox code that works across versions
I have a spreadsheet that has a code that calculates based on boxes that are checked. Unfortunately, depending on what version of Excel you have, it doesn't work so I have one coded differently that ...
The IFS function is only available in Excel 2019 and Excel in Microsoft 365, so it won't work in Excel 2016 and earlier versions.
The "New Version" with 3 times IF will work in all versions of Excel. So as long as some of your users have Excel 2016 or earlier, stick with this formula.
- Thanks Hans! We use the "New Version" as a default with our program, but quite frequently run into issues where it doesn't work for them in which case we have to end up sending the the "Old Version" for it to work. It just causes a lot of confusion. Do you know why this would be or what we could do to avoid this issue?
