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" <mukeshbaviskar....@gmail.com>
To: "Access India" <accessindia@accessindia.org.in>
Cc: "Zujar Shabbir Kanchwala" <zujarbri...@gmail.com>
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/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
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