You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Got a spreadsheet that is built, just missing simple formula:
1-2 person households get 1 item
3-4 person households get 2 items
5-6 person households get 3 items
and so on.
household size is entered in cell b2
simple concept says 1x.5 round up.. would be the solution to the formula… but I never built a spreadsheet before..
can I get the correct way to enter this in numbers??
HI Leo,
Here's another formula that will do what you want.
The formula shown below the table is entered on cell B2, and has been filled down into the rest of the cells in column B.
Dividing the number in column B by 2 returns a result that is 0.5 less than the number of items to be supplied for an odd number of people, and the correct result for an even number of people.
Adding 0.5 to that result brings the result up to the correct result for an odd number of people, and a result the is 0.5 larger that the number of items to be supplied for an even number of people.
The INT function strips the decimal amount (.0 or .5) from that result, and returns the correct number of items for each number of people.
When entering the formula, use / in place of the division sign (÷). Numbers will immediately replace it with the division sign, as seen in the example.
Regarding tutorials: Take a look at the examples available in the Templates included with Numbers. Open one that appears to be similar to what you want to do, then examine the formulas that are producing the results you see.
Regards,
Barry
HI Leo,
Here's another formula that will do what you want.
The formula shown below the table is entered on cell B2, and has been filled down into the rest of the cells in column B.
Dividing the number in column B by 2 returns a result that is 0.5 less than the number of items to be supplied for an odd number of people, and the correct result for an even number of people.
Adding 0.5 to that result brings the result up to the correct result for an odd number of people, and a result the is 0.5 larger that the number of items to be supplied for an even number of people.
The INT function strips the decimal amount (.0 or .5) from that result, and returns the correct number of items for each number of people.
When entering the formula, use / in place of the division sign (÷). Numbers will immediately replace it with the division sign, as seen in the example.
Regarding tutorials: Take a look at the examples available in the Templates included with Numbers. Open one that appears to be similar to what you want to do, then examine the formulas that are producing the results you see.
Regards,
Barry
You wrote "... but I never built a spreadsheet before ..."
Then I would recommend that you watch some tutorials on YouTube search for "basic tutorial apple numbers"
Here one option for the formula in C2.
Ralf
Sorry b2x.5 rounded is what I meant…
Mac numbers basic formula with household size to amount per item
