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...
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))))
SergeiBaklan That formula works! Oh my gosh, thank you SO much! This has been a complete headache and you have really helped.
britt635 , you are welcome, glad to help