Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How can I divide numbers and separate them easily in the Numbers spreadsheet?

I want to divide for example 360/5 and get the five answers in separate cells? like 0, 72, 144, 216, 288

next time it will be 360 divided with another number ex 8, I then need 8 answers


[Re-Titled by Moderator]

MacBook Pro 15″, macOS 12.7

Posted on Aug 14, 2024 7:05 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 15, 2024 4:08 AM

The formula in your email was the original one I posted. I edited my post and changed it to the second one after I thought of a simpler "if" condition. Both do the same thing. I think the second one is better. If you are somewhere that uses a comma for the decimal separator, you need to change the commas in the formula to semicolons.

5 replies
Question marked as Top-ranking reply

Aug 15, 2024 4:08 AM in response to Ockelbo300

The formula in your email was the original one I posted. I edited my post and changed it to the second one after I thought of a simpler "if" condition. Both do the same thing. I think the second one is better. If you are somewhere that uses a comma for the decimal separator, you need to change the commas in the formula to semicolons.

Aug 14, 2024 1:09 PM in response to Ockelbo300


Formula in C2 =IF(AND($B2≠0,C$1<$B2), $A2÷$B2×C$1,"")

Fill right and down to complete the table.

Extend the table to the right if necessary.


Column C will always be zero. Do you really need it?


The two examples had integer solutions. If some will not be integers, I recommend against setting the format to display 0 decimals because the rounding will make it display results that don't quite add up. You might get a sequence like 0, 10, 21, 31, 42, etc. where it goes up by 10 sometimes and 11 other times.





Aug 15, 2024 2:07 AM in response to Badunit

What you describe is just what i´m asking for. But there are two versions of your formula:

Formula in C2 =IFS($B2=0,"",$A2÷$B2×C$1<$A2, $A2÷$B2×C$1,TRUE,"") in the mail from the forum

and

Formula in C2 =IF(AND($B2≠0,C$1<$B2), $A2÷$B2×C$1,"") as posted on the forum


Both will give me a syntax error

Thank you so much for helping!

How can I divide numbers and separate them easily in the Numbers spreadsheet?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.