0

Can anyone help? I can't work out why this is erroring. this section =IF(OR(ISBLANK[Tech £]),"", at the start in bold makes it error.

=IF(OR(ISBLANK([Tech £])),"",IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="Pack 2=PC Only"),"0",IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="Pack 1=Full Kit"),"0",IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="No"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="Pack 2=PC Only"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="Pack 1=Full Kit"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="No"),"0",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="Pack 2=PC Only"),"£23",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="Pack 1=Full Kit"),"£40",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="No"),"Oops")))))))))
3
  • this is formula is was using (which worked) then I wanted to blank the unused cells Jan 21, 2021 at 19:25
  • =IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="Pack 2=PC Only"),"0",IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="Pack 1=Full Kit"),"0",IF(AND([Tech Pay Type]="Paid in Full",[Tech Pack]="No"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="Pack 2=PC Only"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="Pack 1=Full Kit"),"Oops",IF(AND([Tech Pay Type]="N/A",[Tech Pack]="No"),"0",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="Pack 2=PC Only"),"£23",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="Pack 1=Full Kit"),"£40",IF(AND([Tech Pay Type]="Monthly",[Tech Pack]="No"),"Oops"))))))))) Jan 21, 2021 at 19:25
  • What is the error? As per your existing formula, the column name 'Tech £' was not used before, are you sure it exists?
    – UBK
    Jan 21, 2021 at 22:51

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.