| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min of formula equals coming up wrong
try this (works in Excel 2002PL):
D20=His monthly cost (234.25), F20=Hers monthly cost (234.25) D22=His current age in years (59), F22=Hers current age in years (59) =(79-D22)*(12*D20-MIN(12*D20*25%;500)) + (83-F22)*(12*F20-MIN(12*F20*25%;500)) -- ============================== Janusz Pawlinka |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not coming through | Excel Discussion (Misc queries) | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| need help coming up with a formula. | New Users to Excel | |||
| New user needing help with coming up with a formula | New Users to Excel | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Threaded Mode
