| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
| FIND is not "finding" a number in a column which contains the numb | Excel Worksheet Functions | |||
| Find number of days between to dates | Excel Worksheet Functions | |||
| How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Linear Mode
