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(D11=TRUE,G12=TRUE),J17*0.8,AND(D12=TRUE,G11=TRUE),J17*0.8,AND(D12=TRUE,G12=TRUE),J17*0.7),J17)
This is a simulation as part of a larger project for students. The goal is that when they select if they are single/children, single/no children, married/children, married/no children, that the taxes will automatically calculate for them (using the tax key multiplied by J17) in box J20.
Any help I can get is SO appreciated. Thank you!
17 Replies
britt635 the problem isn't really the formula. you have a merged cells. cells j17 and j18 are merged and despite the fact that the formula you posted below has j17 all over it, the sheet I opened has j18 in the formula instead.
I just saw the replies and when I changed the formula to have j17 it worked for me. That said, you could replace it with sum(j17:j18) both in excel and sheet and it should work
mtarler When I change it to J17, it is just copying the number that is in J17/J18, not doing the calculations in the formula. In other words, when I click the appropriate boxes, no change happens like it should. When I use sum(J17:J18), same thing.
The goal is that it needs to calculate the number in J17:J18 by either .75, .80, or .85 depending on the boxes they click.
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
