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.
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
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.
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.
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.
Look at the screenshot of my table. The cells in row 1 need numbers in them.
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!
Hi ,
I live in Sweden and yes, we use a coma as decimal separator. I replaced the coma with semicolon but the formula does not work. It only returns a number zero.
How can I divide numbers and separate them easily in the Numbers spreadsheet?
