Forum Discussion

Copper Contributor

May 07, 2020

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...

Income & Transaction Log .xlsx165 KB

excel

Excel for web

mtarler

Silver Contributor

May 07, 2020

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

britt635

Copper Contributor

May 07, 2020

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.