Excel: Need Help

Discussion in 'Computer Science & Culture' started by Thoreau, Nov 15, 2011.

Thread Status:
Not open for further replies.
Page 3 of 3
  1. Enmos

    Enmos Valued Senior Member

    Messages:
    43,184
    Yes, but if you enter '9', it will return '10' as well.
     
    Enmos, Nov 16, 2011
    #41

  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Trippy

    Trippy ALEA IACTA EST Staff Member

    Messages:
    10,890
    No, I don't believe it does.
     
    Trippy, Nov 16, 2011
    #42

  4. Google AdSense Guest Advertisement



    to hide all adverts.
  5. Enmos

    Enmos Valued Senior Member

    Messages:
    43,184
    Well 10 is the nearest number to 9. I don't know, perhaps you're right. I haven't tried VLOOKUP, so..
     
    Enmos, Nov 16, 2011
    #43

  6. Google AdSense Guest Advertisement



    to hide all adverts.
  7. Trippy

    Trippy ALEA IACTA EST Staff Member

    Messages:
    10,890
    No perhaps about it

    Please Register or Log in to view the hidden image!



    I am right.

    Please Register or Log in to view the hidden image!

     
    Trippy, Nov 16, 2011
    #44
  8. Enmos

    Enmos Valued Senior Member

    Messages:
    43,184
    Yes, you're right. I just tried it

    Please Register or Log in to view the hidden image!

     
    Enmos, Nov 16, 2011
    #45
  9. Enmos

    Enmos Valued Senior Member

    Messages:
    43,184
    Trippy, since you seem to know a lot about Excel, how do you prevent a range from automatically changing when you drag out a cell with a formula in it that contains a range?
     
    Enmos, Nov 16, 2011
    #46
Page 3 of 3
Thread Status:
Not open for further replies.

Share This Page