Forum Discussion
Easy Checkbox help PLEASE!!
I converted a Google Sheets Doc to an Excel spreadsheet and fixed everything except for the one formula I cannot figure out. Here is the formula: =IFERROR(ifs(AND(D11=TRUE,G11=TRUE),J17*0.85,AND...
SergeiBaklan changing the formula to j17 doesnt work either... It is just putting in the same number as whats in J17/18, not doing the calculations in the formula.
I still use the one on Sheets (depending on what students can access) so I would like to keep the formatting the same if possible for consistency.
ANy other ideas?
If change on J17 it works, please check attached
- It just copies the number down. What happens when you click on the boxes?
It calculates something
but I have no idea what shall be corrected result. I only see that formula could be simplified a bit, but that's cosmetic.
- I just sent it to a couple co workers to see if it worked for them and it didn't. Why would this be happening? It very clearly works for you (as shown in your screenshot) but it doesn't work for us. Do you know why?
Your help is truly very much appreciated.