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...
Formula makes calculations with J18. Since you merged J17 and J18, that will be nothing in the latest, number is kept in first of merged cells. If unmerge and put value in J18 formula works:
or use J17 instead.
In general in Excel it's better not to use cells merging and you avoid a lot of potential issues. Better to reformat.
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?
