# Thread: Formula without creating a circular reference

1. 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?

2. [quote name='mitjones' post='799989' date='26-Oct-2009 15:22']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?[/quote]

Try:

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•