quotation mark in formula seems to crash excel!!!

Discussion in 'Microsoft Excel Crashes' started by tt1611, Dec 16, 2008.

  1. tt1611

    tt1611 Guest

    I have a user who is convinced that everytime she enters a quotation mark (")
    in her formula, the application crashes and has to restart. Please see below

    Below is description of formula that caused Excel to close.

    this formula works:
    =if(and(f3>=j3,f3<=l3),"Lower",if(and(f3>=m3,f3<=o3),"Middle",if(and(f3>=p3,f3<=r3),"Upper",f3>r3,"Above Upper","?"))))
    if try to enter "if(f3<j3,"Below Lower", in front of formula, Excel closes
    when hit " key


    this formula works when entered left to right:
    =if(f3<j3,"Below
    Lower",if(and(f3>=j3,f3<=l3),"Lower",if(and(f3>=m3,f3<=o3),"Middle",if(and(f3>=p3,f3<=r3),"Upper",f3>r3,"Above Upper","?")))))
    formula will not work if try to edit-something with " key in formula is
    causing Excel to close

    this is just one example of several that she has. I have researched high and
    low and cant find any information on this. Can I please have your thoughts on
    what you think is causing excel to shutdown?
     
    tt1611, Dec 16, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page