get rid of #value!
get rid of #value!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: get rid of #value!

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    dallas tx
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =IF(OR(J22={"n/a",0}),"n/a",J22/86400)

    [ This Message was edited by: Mark W. on 2002-04-16 14:45 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



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

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    dallas tx
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    got it!!

    [ This Message was edited by: Escher on 2002-04-16 14:54 ]

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    hi

    No need to drag the cell will circula!

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com