-------- Original Message -------- From: Bill Mc Taggart <[email protected]> To: [email protected] Date: Fri, 11 Sep 2009 11:18:31 +0100
> I am using open office 3.1 on Windows XP > I seek advice on how to devide 5000 differing values in column I by > 0.46 and show the recalulated value for each line in the next column > J > How do I achieve this? > I am not subscribed to this list, please CC me. > Regards, > Bill Not sure if this is the answer to your question, because the solution seems too simple, but here goes. Assuming the values in column I start at row 1. o In cell J1 enter the formula =I1*0.46 o Copy cell J1 to the clipboard o Select/highlight cells J2 through J5000 (eg. Click cell J2 and hold down Ctrl+Shift keys and press End key) o Paste the formula from the clipboard into the highlighted cells. Hope this helps. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
