get rid of #value!

Escher

New Member
Joined
Apr 4, 2002
Messages
13
here is formula

=J22/86400

i need a formula that puts an n/a in if a 0 or n/a is entered in j22...

i am confused....

and does anyone have any good links to learn if statements and arrays??? thanks guys
you guys rock!!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
=IF(OR(J22={"n/a",0}),"n/a",J22/86400)
This message was edited by Mark W. on 2002-04-16 14:45
 
Upvote 0
=J22/86400
should circula?? just as good its a warning a leaves a blue blob.... to left of cell.

i need a formula that puts an n/a in if a 0 or n/a is entered in j22...

try conditional format just cell J22 so that if formul entered as aboue displays alert.





and does anyone have any good links to learn if statements and arrays??? thanks guys
you guys rock!!

This must be the easiest question no one will challebge.. you are in the right place track the posts and search the site using search facility.

Im sure aftr 5 minutes you see names of Gurus popping up.. formulas you want,, well you will travel the world to find a better poster and guru of the formula that my great friend Aladin from Holland, i strongly suggest checking his posts.. they will have the question and his answer.. no better source REALY WORLD i know of.. also suggest checking the members page and check the top 5 posters sort byu post tab, these guys have web pages check them .. your find they are all awesome and dan good.

I am ranked 5 but no web site, so sorry about that one.

But stick as many hours in as i do and you be a guru in no time ... MrExcel is the world leader that im sure.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

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?

Disable AdBlock

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
Back
Top