|As for your second problem:|
D6 is a percentage that has to be capped at 200% for calculation purposes.
Something could be written, but it would be very long and confusing, because, as you know with a formula, the cell your working from cannot change the contents of another cell.
So you can not change the value of D6 unless your in D6 so in your formula in every instance where you have D6 you would need to insert an additional IF() statement to check the value and then do the computation.
It would look something like:
I could write something to actually cap D6 at 200% in the cell itself
That would probably be the easiest way to go.
As you can see, the layout of your sheet can have a lot to do with how much and what kind of processing you can do.
I don't know what your sheet looks like, but perhaps a redisign?
Also, in the future, different questions should be asked in their own threads.
Keeps things from getting confusing when answering and reading.
message edited by mmcconaghy