On Friday 02 March 2012, 13:59:50 PDA1 wrote: > Cell A1 has the number 100 > > Cell A2 has a percentage- 2.9%
Enter into A3: =A1+A1*A2 Take care of having a real "number" in A1 and A2 and not a text. Tip: Numbers are right-aligned, text is left-aligned generally. To make sure, you have a number in e.g. A2, you should - enter 0.029 - format the cell as Number/Percent (Format > Cell > Numbers: select "Percent") Regards, Nino -- 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