Excel 2007 : Help needed to write a subtraction formula

Hi fxtrader,

Try this formula in C1

=ABS(A1-B1)*10^((INT(ABS(LOG(ABS(A1-B1)))))+1)

It seems to me you are trying to get numbers between 1 and 10.

Hope that is what you're looking for.

Thanks again!

The anwer will not always be betwee 1 - 10. The numbers I'm using in the calculation are currency prices and I'm trying to calculate the difference between the two in "pips". Pips are the unit of measure in currency trading. e.g. 125.145 - 120.00 = 514.5 pips

Any suggestions?