Forum Discussion

britt635's avatar
britt635
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...
excel
Excel for web
britt635's avatar
britt635
Copper Contributor
May 07, 2020
It just copies the number down. What happens when you click on the boxes?
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 07, 2020

    britt635 

    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.

    • britt635's avatar
      britt635
      Copper Contributor
      May 07, 2020
      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.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 08, 2020

        britt635 

        Is that on the file I uploaded or on your version of the file?

        To make things easier let simplify the formula first, as

        =J17*IFS(D11*G11,0.85,D11*G12,0.8,D12*G11,0.8,D12*G12,0.7,TRUE,1)

        In any empty cells enter =D11, =D12, etc to be sure check boxes are working on your file. Next, try mtarler suggestion, but I'd prefer to do that not in formula bar but by Formula->Evaluate formula option on ribbon.

        Please check with attached file.

    • britt635's avatar
      britt635
      Copper Contributor
      May 07, 2020

      SergeiBaklan What the heck?! Why is it not working for me?? 😞 

       

      I copied the exact code from your example and nothing happens on my end when I click the boxes like it does for you. DO you know why that would happen??

Resources