• New Patreon Tier and Early Access Content available. If you would like to support AVForums, we now have a new Patreon Tier which gives you access to selected news, reviews and articles before they are available to the public. Read more.

Need help making formulas on Mac Numbers


Distinguished Member
Anyone know how to do a percentage formula for multiple cells for 2 rows? For example B2:B10/C2:C10%.
So far I get an error with this formula but can set it up per pair of cells.


Distinguished Member
Don't know Mac Numbers but if I did it in a spreadsheet

=product(sum(B2:B10)/sum(C2:C10), 0.1)

Thanks, computer says no to that too.

Edit: I found that it works logically in Excel - Mac Numbers very limited.
Last edited:

The latest video from AVForums

SVS Prime Wireless Pro Powered Speakers - Review Coming Soon
Subscribe to our YouTube channel
Support AVForums with Patreon

Top Bottom