| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find what cells equal a certain number?
I have a string of dollar amounts and I am trying to see if there is a quick
way to find out what amounts will total a fixed number. For example, I have a number of cells, and I want to see what cells will total $500,000.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i find what cells equal a certain number?
If you have to ask then you don't want to know the answer. <g http://www.tushar-mehta.com/excel/te...ues/index.html has some possible ways to do it. My approach is to apply the amount against the oldest invoice and work up from there. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "tdub" wrote in message I have a string of dollar amounts and I am trying to see if there is a quick way to find out what amounts will total a fixed number. For example, I have a number of cells, and I want to see what cells will total $500,000.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find combination of cells that equal a sum | Excel Worksheet Functions | |||
| how can I find which cells in a dataset equal a specific value | Excel Worksheet Functions | |||
| How can I find the equal cells in Excel | Excel Discussion (Misc queries) | |||
| find smallest number not equal to 0 | Excel Worksheet Functions | |||
| The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions | |||
Linear Mode
