PC Review


Reply
Thread Tools Rate Thread

quotation mark in formula seems to crash excel!!!

 
 
tt1611
Guest
Posts: n/a
 
      16th Dec 2008
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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Formula For Finding a Quotation Mark In a String T. Valko Microsoft Excel Worksheet Functions 0 16th Jun 2009 02:05 AM
Re: Formula For Finding a Quotation Mark In a String Fred Smith Microsoft Excel Worksheet Functions 0 16th Jun 2009 01:47 AM
Formula For Finding a Quotation Mark In a String Tiziano Microsoft Excel Worksheet Functions 0 16th Jun 2009 01:25 AM
Why isn't quotation Mark between quotation Mark(String defining) possible? kimiraikkonen Microsoft VB .NET 7 12th Oct 2007 04:23 AM
Why isn't quotation Mark between quotation Mark(String defining) possible? kimiraikkonen Microsoft VB .NET 1 10th Oct 2007 08:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:01 PM.