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?