solver...
 

I have four cells that I enter numbers into and the rest of the sheet has
formulas setup. Is there a way to have excel try different numbers until it
finds the max value in a certain cell? I believe I would use solver but I
can't get it to work. I enter numbers in cells B5, B8, B11, and B14. I want
cells K2, K5, K8, K11, K14, K17, and K20. Is there a way to do this? Thanks.