find a number broken into more than one number
 

Hi All,
I have a number for eg. $70.76. I would like to know if excel is able to
tell me if it is broken down into several numbers in a list, say:
20.00
30.56
40.26
50.00
60.00
At a glance the $70.76 is made up of $30.56 and 40.26 but is there a formula
which would indicate this to me?

find a number broken into more than one number
 

I wouldn't have thought so as $30.56 and $40.26 make $70.82 but if your
number is the result of a formula, pressing F2 should show the cells making
up the number.

"shapiro" wrote:

Hi All,
I have a number for eg. $70.76. I would like to know if excel is able to
tell me if it is broken down into several numbers in a list, say:
20.00
30.56
40.26
50.00
60.00
At a glance the $70.76 is made up of $30.56 and 40.26 but is there a formula
which would indicate this to me?