Forum Discussion
Help with finishing these formulas please!
I have:
Total batch weight
I don’t know what formula to use for this.
Single portion weight (g)
A2/C2
Single portion potency (mg)
C5*D2
CBD batch potency (mg)
C6/E2
And then I need them to give me:
Total concentrate weight
And
CBD oil to use
But I can’t figure out these two last things. And also when I put in the A2/C2 and the C6/E2 It gave me A warning sign saying “there are one or more circular references where formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly“
And I’m not sure what that means
Any help is much appreciated!
16 Replies
Shanae1180 Would be helpful if you could show what exactly you have in each of the cells. A circular reference is cause be a formula that, directly references it self. For instance, when you enter in A2, =A2 , that's a circular reference. The same when you enter =B2 in cell A2 where B2 contains the formula =A2.
Now, these are very obvious examples, but in real life circular references can sometimes be a bit more difficult to spot and correct. But when you click on the Error Checking icon on the Formula ribbon, you can get some clues as to where to start.
Hi @riny_van_Eakelen ! Thank you so much for your reply! I’ve taken a bit to get back to you because I’ve been trying to figure out how to send photos to you to show you what I mean. I hope these help
Shanae1180 Not sure what you have in mind but all formulae on row reference to cell in rich they reside. That's causing circular references as explained in my previous post.
