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
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 08, 2020

SergeiBaklan this is what happens when I download your copy with the new formula. It still does not calculate as it needs to.  It says #NAME?. 

 


When I download your copy a few messages up, it just doesnt calculate at all on my end and shows whats in box J17.

Sorry for the bad photo. I only have Excel on my work computer and it restricts screenshots. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 08, 2020

    britt635 , you are welcome, glad to help

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

    SergeiBaklan That formula works! Oh my gosh, thank you SO much! This has been a complete headache and you have really helped. 

Resources