Hi Community,
I have a formula that is leaving me stuck and I'm not sure how to solve it and hoping you can help.
Issue: the formula should be trying to calculate that IF D50/D49 results in an error (i.e. if both are 0 and returns DIV error) then it should return "BCB Auto Fail" if true, or if FALSE then divide D50/49, and IFcells C14 - C37 ="---Select---" then it should return "N/A".
I'm getting a value error indicating its the wrong data type, not sure where i'm going wrong.
I have a formula that is leaving me stuck and I'm not sure how to solve it and hoping you can help.
Code:
=IF(ISERROR(D50/D49),"BCB Auto-Fail",D50/D49),IF(AND($C$14,$C$18,$C$22,$C$26,$C$37,$C$40,$C$44)="---Select---","N/A")
Issue: the formula should be trying to calculate that IF D50/D49 results in an error (i.e. if both are 0 and returns DIV error) then it should return "BCB Auto Fail" if true, or if FALSE then divide D50/49, and IFcells C14 - C37 ="---Select---" then it should return "N/A".
I'm getting a value error indicating its the wrong data type, not sure where i'm going wrong.