Short Formula to solve!

[sazuka]

Hi all, I am simply a beginner. But Im trying my best. I have big issues trying to figure out this formula

i hope someone can help a newbie out

A1 = 5
A2 = 2

I want to output how many times A2 fit in A1, If True(How many times does it fit in A1). If False show 0


Output for example on top would be:

B1 = True
B2 = 2
B3 = 1




It would be like

B1= IF(A1>A2;True, False)
B2 = IF (b1=True; Find out how many Times A2 fit in A1 and Output)
B3 = IF b2 = True; how much left over

[Pete_UK]

Put this in B1:

=(A1>=A2)

It will return TRUE or FALSE - Note that I've made it >=, as A2 will still divide into A1 if they are equal.

Put this in B2:

=IF(B1;INT(A1/A2);0)

I assume you use semicolons rather than commas to separate the parameters.

Hope this helps.

Pete

[shg]

In B1, =A1>A2

In B2, =INT(A1/A2)