# Need to get rid of "N/A"

#### thewiseguy

##### Well-known Member
How would I get rid of the "N/A" value and replace it with "0?"

=P14*(S14*T14)+R14

thanks!

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Andrew Poulsom

##### MrExcel MVP
Which of those cells can contain #N/A?

#### thewiseguy

##### Well-known Member
maybe the better question is: how do i get this formula to return a "0" value instead of N/A:

=VLOOKUP(E29,LABOR1,11,FALSE)

#### Jonmo1

##### MrExcel MVP
The general context to eliminate N/A is

=IF(ISNA(originalformulahere),"",originalformulahere)

so for your example
=IF(ISNA(VLOOKUP(E29,LABOR1,11,FALSE)),"",VLOOKUP(E29,LABOR1,11,FALSE))

#### Andrew Poulsom

##### MrExcel MVP
Try:

=IF(OR(ISNA(P14),ISNA(R14)),0,P14*(S14*T14)+R14)

#### thewiseguy

##### Well-known Member
Excellent! thank you guys.

#### thewiseguy

##### Well-known Member
does the same formula work for #DIV/0!? I tried it and the formula works but I cant get the #DIV/O! out of there.

#### Jonmo1

##### MrExcel MVP
change ISNA to ISERROR (this will cover ANY error message)

#### thewiseguy

##### Well-known Member
change ISNA to ISERROR (this will cover ANY error message)

still getting the DIV/O! error.

Replies
2
Views
81
Replies
7
Views
224
Replies
2
Views
101
Replies
3
Views
164
Replies
1
Views
71

1,191,032
Messages
5,984,247
Members
439,879
Latest member
KingGoulash

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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