=IF(R8="cl", O8, "other value if false") Best Regards, Zujar…
An optimist laughs to forget and a pessimist forgets to laugh! -----Original Message----- From: AccessIndia [mailto:[email protected]] On Behalf Of Mukesh Sent: Saturday, April 06, 2013 10:24 PM To: Access India Subject: [AI] Excel query Hello friends, I have a problem in the following formula. Please suggest correction. If cell ‘r8’ equals “cl” the value of cell ‘o8’ should come in cell ‘i8’ automatically by formula. Thank you. Regards Mukesh Baviskar Mobile: 9403161157 Skype id: mukeshbaviskar Blog: http://mukeshbaviskar.blogspot.com 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
