Dear Mukesh, This email is in continuation to what zoher has stated in the previous email. Excel consider "blank space" as an entry so it is proposed to modify the formula mentioned by zoher as: =if(a1>=35,"pass","") In the above line I have removed the blank space between the last two " signs i.e. instead of quote space quote you can only write quote quote (without a blank space). This will ensure that no value is stored in the cell in case the condition is false. It may be noted that for excel even a blank space is a valid entry (although it is not visible in printouts or screen) You are requested to read my email in continuation to zoher's email only. Hope above helps.
Regards, Vivek ________________________________ My E-mail Address has changed. Kindly use "singha...@indianoil.in" This Message was sent from Indian Oil Messaging Gateway, India. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. ________________________________ Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
