Help, Apple Numbers Formula

File: IMG_4115.png (196KB, 1242x2208px) Image search: [Google]

196KB, 1242x2208px

>>17993815
Let me do an example:
>pic related

IF('97.7...8'='100'−(2.2...3); (('100-97.7...8')÷(2.2...3))+'1'+1; '1')

This will return 3, for F3, F4 and F5.
For F6 should return 6, but the condition will fail(?!) and return the cell above it as per the ELSE statement, and so 3.

Why Apple numbers and not excel or Google sheets? There are hundreds of tutorials out there for software like this. Not trying to grill you, just legitimately curious.

>>17993815
I really want to help you here, but I'm having trouble figuring out what you want to do.
1. the ('100-CellToTheLeft')÷(100÷45) just produces a column of 1,2,3,4.. why do you need multiple copies of the same value, three 97.777 and so on, why not just have one and have one column with the numbers 1,2,3,4..
2. what is the connection between the numbers on column E and G? Do these correspond to some real world situation or system?

Figured it out.
let A be 0,1,2,3,4,5...
let C be A+1
let B1 be 1 (first row of B)
let B2 and onwards be A+1+previousB
this will produce your column G, here in column B.
Good luck.

Figured out that the repetition of numbers corresponds to the value of the number, i.e. the number 3 is repeated three times. Is there a way to produce this without going through the data again once generated.. Can you really do this in a spreadsheet?

#include <stdio.h>

int main(void)
{
int a,b=1,c;

for( a=1; a<6; a++ )
{
for( c=0; c<b; c++)
{
printf("%d\n", b);
}
b = a+1+b;
}

return 0;
}
/*next time i do your homework i want to get paid.*/