Find value for a cell that meets a condition?

Originally Posted by lanix

BETALNING means payment, I don't know if that's what the function is called in English. I haven't found any list with Swedish-English function translations (it sucks I can't use English functions in Swedish Excel).
It's at least the function where you enter loan, % and for how many years.

These are the ones that are to be compared (minus just so I don't get minus in the answer, didn't found any other way to fix it):
=B24-BETALNING($B$17;$B$18;$B$16)
and
=$B$7*$B$6

It's the last one I want to get bigger.
B7 is linked to B3. It's in only B3 I enter the value. It's the max value in B3 I seek.

B24 contains a cell that's linked to B3 too.
=B22*B23

B23 is linked to B3.

Maybe a bit too confusing. Don't think it'd help much posting the Excel-file as it's in Swedish.

Here you go Lanix: http://cherbe.free.fr/traduc_fonctions_xl97.html

Översätt på nu!