# Need help with formulas

#### DKRbella0814

##### Board Regular
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)))

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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)

Replies
5
Views
185
Replies
1
Views
139
Replies
14
Views
353
Replies
3
Views
331
Replies
9
Views
741

1,219,574
Messages
6,149,078
Members
450,855
Latest member
onecodevee01

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back