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?
