=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.