Dynamic Cell Reference?

[kestefon]

I'm trying to build a dynamic formula where a cell reference shifts one column over when a certain percentage changes. It's hard to explain, but the attached workbook should make it clear what I'm trying to accomplish.

Any thoughts?

SampleWorkbook.xlsx

[MarvinP]

Hi,

This looks like a simple IF kind of answer,

If the top row = 100% then use one formula and if not they use the other one..??

In Q6 it might look like:

=IF(Q$2=1,(Q$3*$E6),(Q$3*$F6))

[Kaper]

Q6:

Please Login or Register  to view this content.

and copy down/right