Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

brainwave89

macrumors 6502
Original poster
Jul 7, 2006
476
8
I need help creating a formula in Numbers on my iPad 2. In cell A1 I have a dollar amount of $10. In A2 and A3 I have the number five in each one. In A4 I need the total of A2 and A3 multiplied by $10 that is in A1. A4 should then have $100. What will the formula be to accomplish this task?

Thank you for looking.
 
Thank you very much Squashy.

If I had numbers in cells A2 through A16 with a total in A17 of those numbers multiplied by the $10 in A1, what would the formula be?

Thank you.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.