Dear Vivek,
Thank you for modification and explanation.
Mukesh
--------------------------------------------------
From: "Singhal, Vivek" <[email protected]>
Sent: Saturday, December 15, 2012 12:11 PM
To: <[email protected]>
Subject: [AI] cell formula if not true
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 "[email protected]"
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/[email protected]/
To unsubscribe send a message to
[email protected]
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
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/[email protected]/
To unsubscribe send a message to
[email protected]
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
