Hello Zoher,
It's working fine and giving me appropriate result in abbreviation and
calculations. Thank you for solution.
Regards
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "zoher kheriwala" <[email protected]>
Sent: Saturday, December 15, 2012 10:07 AM
To: <[email protected]>
Subject: Re: [AI] Blank cell formula if not true
It happends when you put only true condition and does not instruct the
formula what to display when the condition is not true. at that time by
difault the formula returns the value fals. here is the solution.
after writing the text what to display if cundition is true and closing
the " put , and start " and press space bar and close " and end your
formula. I dontknow what condition you have given but I will try to
explain with my simpel formula
=if(a1>=35,"pass") in this example the value of a1 = or > then 35 then the
cell containing formula will display pass and if the condition is not true
then it will display fals. now we will currect the formula.
=if(a1>=35,"pass"," ")
in this formula the cell containing formula will display blank if the
condition is not true.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message -----
From: "Mukesh" <[email protected]>
To: "Access India" <[email protected]>
Cc: "Zujar Shabbir Kanchwala" <[email protected]>
Sent: Saturday, December 15, 2012 8:30 AM
Subject: [AI] Blank cell formula if not true
Hello Friends,
I have created a if formula in cell w5, x5, y5, z5
When the condition is not true the formula cell displays the text 'false'
in the cell. I have concatenate formula in cell 'aa5' for these 4 cells
respectively. Which gives me the abbreviation of these cells. At a time
there is only 1 condition is true in these 4 cells and 3 cells displays
the text 'false' which gives me the wrong abbreviation in cell 'aa5' for
ex. 'falsefalseakfalse'. I want to display the text 'ak' which is true
and hide other 3 cells containing the text 'false'. That means when there
is a text 'false' in that particular cell the cell must be blank
automatically and give me the result 'ak' only in cell 'aa5' instead of
'falsefalseakfalse'. Please guide me how to tackle this problem because
the abbreviation in cell 'aa5' is important for calculation. Thanking you
in anticipation.
Regards
Mukesh Baviskar
Mobile: 9403161157
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
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
