| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
gain-loss
A1 B1 C1 D1 E1 F1 G1
100 5.00% 95 5 95 5 100% i need G1 to increase as E1 increases. the way it works now if E1 increases then G1 decreases. the way the formula works is A1 is the base B1 is the targeted percentage differance between A1 and C1. F1 is the gain or loss of E1 and C1. So if E1 goes below C1 then I need G1 to decrease and if E1 increases then G1 needs to increase. Can someone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for calculating wt gain or loss cumulative in excel | Setting up and Configuration of Excel | |||
| How can I display a loss or gain (currency) | Excel Worksheet Functions | |||
| Weight Gain Loss | Excel Discussion (Misc queries) | |||
| does anyone have a chart for weight gain or loss in kilos? | Excel Discussion (Misc queries) | |||
| Excel Template to track Gain/Loss for IRS purposes | Excel Discussion (Misc queries) | |||
Threaded Mode
