On 10 March 2016 at 18:10, Beau Thompson <[email protected]> wrote: > Hi All, > I have a question about a drop don box and a if > k2 an k3 have names in it k2 Beau k3 john > m2 is drop down $data.$K$2:$K$3 > > I like to do a if in o2 that would be what ever name is not selected in m2 > thanks Beau
=IF(M2=K2,K3,K2) -- T. R. Valentine A rich heart may be under a poor coat. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
