| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference 2
How do I have a cell look at another cell and make a calculation. For example:
A B C (197) 3500 500 If column A is less than B then have the calculation of the amount of (C) it would take to bring it to positive standing. The answer should be 4000. That is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197. If (A) was 3501 then I would have a return value of 0. I would not need to replenish. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
![Jackie Morin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
