| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make a X amount equal $300,000
I am lost on finding out how to do this formula 480,000-?=300,000
How do i turn that question mark into a formula so that my answer is always 300,000. I want to make that ? equal to 180,000 in the other box. Any body know how to do that????? -- Cheers!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make a X amount equal $300,000
Let's say you have the following:
A1: 480,000 B1: =A1 - 300,000 HTH, Barb Reinhardt "Valiant" wrote: I am lost on finding out how to do this formula 480,000-?=300,000 How do i turn that question mark into a formula so that my answer is always 300,000. I want to make that ? equal to 180,000 in the other box. Any body know how to do that????? -- Cheers!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| find all employees whose total salaries equal a given amount | Excel Discussion (Misc queries) | |||
| make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
| I want a series of letters to equal a dollar amount? | Excel Discussion (Misc queries) | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Linear Mode
