Formula help

[serge]

I need a formula in A3 that will give me the different between 2 numbers BUT ONLY the 2 first digits of the millions.

A1 25,000,000
A2 15,000,000
A3 10

Thank you.

 

[dfenton21]

can you not just divide the difference by 1,000,000 i.e

=(A1-A2)/1000000

 

[shg]

A couple of options, depending on desired rounding.

=INT(A1-A2)/1000000

=INT(A1/100000) - INT(A2/100000)

 

[Aladin Akyurek]

I need a formula in A3 that will give me the different between 2 numbers BUT ONLY the 2 first digits of the millions.

A1 25,000,000
A2 15,000,000
A3 10

Thank you.

Assuming that A1 and B2 both have to be >= 10^6...

A3:

=IF((A1>=10^6)*(A2>=10^6),TRUNC((A1-A2)/10^6),"")

 

[serge]

Thank you to the 3 of you I've got more than I asked.
Serge.