Now that I've confused you completely, this is what I'm trying to do...

The PV-style calc also includes the rate factor in its final profit determination - the importance of this is that it is used in both calculations. I am trying to set up a cell in the final comparison that essentially says 'here is the difference with your rate factor...you need to use this other rate factor to get zero difference'. Essentially, I am trying to put together a goal seek via formula. I use goal seek frequently, and have already used it in trying to work out an automated formula. However, if I can, I really want to have an automatically calculating cell that will provide the same information as the goalseek.

Does anyone know if this is possible? Because the overall calcs are quite long, I can't really explain them all fully, though if someone thinks they might have a solution if they see it in more detail, I'd be happy to email them the file to have a look at.

Thanks for any advice!