find a number broken into more than one number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank Function and Number that are close together 1
SORTING BY ODD OR EVEN NUMBERS 1
lookup row number 3
Can one use automatic numbering in Excel like that in Word? 1
Need a formula for a descimal integer into a whole number 1
using an IF function for a total 4
excel macro 1
Number of the day of the year 3

Back
Top