=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:accessindia-boun...@accessindia.org.in] 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/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