Okay, be gentle. Am feeling very fragile and very fed up of this now. It's teddies out of the pram time. I'm trying to work out how to repeat a formula going down a spreadsheet. So in column F there's a value which changes row by row but I always want to get 20% of that number to put in column G.
So for cell G10 for example, I would want the formula =PRODUCT(F10,0.2). In cell G11, I want =PRODUCT(F11,0.2) Is there a way of getting the formula to repeat automatically row by row without having to type it in again and change the cell reference each time?
Formula Shows Up As A 0 (circular Reference For Mac Free
I realise this is probably a very, very simple question looking at the other topics but for the sake of my health, please can you help? Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
All postings and use of the content on this site are subject to the.