CODEWITHSUNDEEP
excelcircular-reference
movietime
movietime

Reputation: 101

Excel Function- Circular Reference

I am trying to split cell culture in my lab and want to create an excel spreadsheet with a formula that will calculate the amount of culture required to be transferred (Cell B2) based on a measure cell density (input into cell A2) in order to receive a particular cell density of the culture. The general formula is:

(X ml Culture)(count VCC) = (Seeding density target)(media + X ml Culture) Where X ml of Culture is to be cell B2 and calculated for when the lab technician inputs a value for the 'count VCC' (cell A2).

So, essentially I want to write a program that will calculate for cell B2 when a value is input into cell A2, where:

(B2)(A2) = (0.5)(50 + B2)

B2= ((0.5)*(50 + B2))/A2

However, I keep receiving the circular reference warning. Unfortunately, I have been unable to isolate B2 on one side of my equation as well. Is there a way I can write a program that will subsequently solve for B2 when a value for A2 is input? So if 3.00 was input for A2, it will cause B2 to be calculated as 10?

Upvotes: 1

Views: 131

Answers (1)

Charles Williams
Charles Williams

Reputation: 23550

Rearranging the formula to eliminate the circular reference I get

B2=25/(A2-0.5)

Upvotes: 1

Related Questions