Steve Fisher wrote: > Enter "X" in B1, then enter following formula in A1 then copy formula to A2 > =if(b1="X","AAA","BBB"), it copies the value "AAA" and not the formula > =if(b2="X","AAA","BBB").
If I copy the formula from A1 to A2, the formula works as I would expect; the formula in A2 is =IF(B2="X","AAA","BBB"). How exactly do you copy the formula from A1 to A2? Do you use: - (on Cell A1) Right Click > Copy (and then on Cell A2) Right Click > Paste - Select A1, click and drag (down) the bottom left corner of the cell - Select A1, Ctrl+C, select A2, Ctrl+V - Some other method? Also, I see you are using LibreOffice version 3.4.3; on which operating system (Windows, Linux, Mac)? Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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