| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Answer's a little more complicated than regular formulas, but what do I need to do?
I have three columns: "Number 1," "Number 2," and "Difference" (which
is Num 1 - Num2). In a given row, I want to be able to enter any 2 of the fields and have Excel calculate the 3rd one. I.e.: (=x are the numbers excel calculates. The other numbers I type in) Num1 Num2 Diff 4 2 =2 =2 1 1 3 =2 1 How can this be done? Thanks, Jordan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Formulas | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Threaded Mode
