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.
Similar Threads
  1. Rob Bovey

    Re: Excel instance in task manager after Excel Crash

    Rob Bovey, Jul 10, 2003, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    1,364
    Rob Bovey
    Jul 10, 2003
  2. ian duffy

    excel 2000 crash in excel for win 95

    ian duffy, Aug 2, 2003, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    530
    ian duffy
    Aug 2, 2003
  3. JBonyun

    Solver and Formula Bar crash (Excel 2003)

    JBonyun, Sep 2, 2004, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    292
    JBonyun
    Sep 2, 2004
  4. Guest
    Replies:
    1
    Views:
    196
    vandenberg p
    May 3, 2006
  5. Margot

    Opening quotation marks

    Margot, Jul 10, 2008, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    234
    Gary''s Student
    Jul 11, 2008
Loading...

Share This Page