Help with a calcualtion formula.....

Hi,

I need to write a spreadsheet where i will input two figures and it will work out the multiples of 50,000,000 and what each 50,000,000 is worth

i.e. I have 125,000,000 vs $ 200,000,000 (The data i will fill in) and need the answer as

2 x 50,000,000 = 80,000,000
1 x 25,000,000 = 40,000,000

125,0000 200,000,000

Can anyone help me to write this formula?

Don't really understand what you want to do?

value of 50,000,000 and any difference.

if 100,000,000 has a value of 200,000,000 the answer is 2 x 50,000,000 vs 100,000,000

or if 125,000,000 is worth 250,000,000 the answer is 2 x 50,000,000 vs 100,000,000 and 25,000,000 vs 50,000,000 (50,000,000 +50,000,000 + 25,000,000 = 125,000,000)

I just want to put the first 2 figures in and for the spreadsheet to work out the multiples of 50,000,000

int(x/50e6) will give the number of 50M's in x.
mod(x/50e6) gives the remainder.