Formula without creating a circular reference

Topic

New Reply

I have a spreasheet that calculates totals in column AF. The total comes up to 99,464,521; however, I have a ceiling whereby I’d like to limit the total to 98,864,862. I need to keep the math and spreadsheet design intact but in row 96 perform math that brings AF back down to this number. I know how to do the math but it creates a circular reference.

Is there a way around this?

Reply | Quote

Replies

I have a spreasheet that calculates totals in column AF. The total comes up to 99,464,521; however, I have a ceiling whereby I’d like to limit the total to 98,864,862. I need to keep the math and spreadsheet design intact but in row 96 perform math that brings AF back down to this number. I know how to do the math but it creates a circular reference.

Is there a way around this?

Try:

=MIN(SUM(AF1:AF95),98864862)

Reply | Quote