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...
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.
That most probably means your version of Excel doesn't support IFS(). Use nested IF() instead
=J17*IF(D11*G11,0.85,IF(D11*G12,0.8,IF(D12*G11,0.8,IF(D12*G12,0.7,1))))
britt635 , you are welcome, glad to help
SergeiBaklan That formula works! Oh my gosh, thank you SO much! This has been a complete headache and you have really helped.