Formulas in Numbers
How do I get column F to automatically multiply by .655 and the answer to populate column J? Thank you.
How do I get column F to automatically multiply by .655 and the answer to populate column J? Thank you.
In column J: [first cell in question in F] * .655. Then replicate first cell in J with the formula down column J.
Numbers' help function used to be pretty good at explaining and showing examples; I haven't used in in years but I'd imagine the process to not have been changed.
Formulas and Functions Help - Apple Support (SA)
Although it's kinda "hidden" on the Community topics site, if you click on "See More Topics", then click on "Applications and Services" you'll see there's a Community topic specifically for Numbers. (In the event Stumpy's response doesn't work for some reason).
Formulas in Numbers