Need help with formulas

[DKRbella0814]

All of the below formulas are in working order; the one thing I would like to do is add programming language to say that

- if the formula returns an error, then I want a "" blank in the cell; otherwise, perform calculations as indicated.

can someone help me out? Thanks!

=IF(AND(ISBLANK(VLOOKUP(A2,Data!B2:DU2,13,FALSE)),VLOOKUP(A2,Data!B2:DU2,14,FALSE)<>""),VLOOKUP(A2,Data!B2:DU2,14,FALSE)/60,IF(AND(VLOOKUP(A2,Data!B2:DU2,13,FALSE)<>"",VLOOKUP(A2,Data!B2:DU2,14,FALSE)<>""),(VLOOKUP(A2,Data!B2:DU2,13,FALSE)*60+VLOOKUP(A2,Data!B2:DU2,14,FALSE))/60,IF(AND(ISBLANK(VLOOKUP(A2,Data!B2:DU2,13,FALSE)),ISBLANK(VLOOKUP(A2,Data!B2:DU2,14,FALSE))),"",VLOOKUP(A2,Data!B2:DU2,13,FALSE))))


=IF(F2="","",IF(F2>0,((VLOOKUP(A2,Data!$B2:$DU2,19,FALSE)*Calculations2!D2)+VLOOKUP(A2,Data!$B2:$DU2,12,FALSE)),(VLOOKUP(A2,Data!$B2:$DU2,19,FALSE)*Calculations2!D2)))

 

[T. Valko]

All of the below formulas are in working order; the one thing I would like to do is add programming language to say that

- if the formula returns an error, then I want a "" blank in the cell; otherwise, perform calculations as indicated.

can someone help me out? Thanks!

=IF(AND(ISBLANK(VLOOKUP(A2,Data!B2:DU2,13,FALSE)),VLOOKUP(A2,Data!B2:DU2,14,FALSE)<>""),VLOOKUP(A2,Data!B2:DU2,14,FALSE)/60,IF(AND(VLOOKUP(A2,Data!B2:DU2,13,FALSE)<>"",VLOOKUP(A2,Data!B2:DU2,14,FALSE)<>""),(VLOOKUP(A2,Data!B2:DU2,13,FALSE)*60+VLOOKUP(A2,Data!B2:DU2,14,FALSE))/60,IF(AND(ISBLANK(VLOOKUP(A2,Data!B2:DU2,13,FALSE)),ISBLANK(VLOOKUP(A2,Data!B2:DU2,14,FALSE))),"",VLOOKUP(A2,Data!B2:DU2,13,FALSE))))


=IF(F2="","",IF(F2>0,((VLOOKUP(A2,Data!$B2:$DU2,19,FALSE)*Calculations2!D2)+VLOOKUP(A2,Data!$B2:$DU2,12,FALSE)),(VLOOKUP(A2,Data!$B2:$DU2,19,FALSE)*Calculations2!D2)))

If you're using Excel 2007 or later then it's pretty simple.

=IFERROR(your_formula_here,"")

If you're not using Excel 2007 or later then it looks like it could get really ugly!

I think I might just use those formulas as intermediate results and then use a "good" formula to test the results of those formulas. Like this:

First formula in A1, the other formula in A2, then:

=IF(ISERROR(A1),"",A1)
=IF(ISERROR(A2),"",A2)