View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Janusz Pawlinka Janusz Pawlinka is offline
external usenet poster
 
Posts: 17
Default 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