Jan 19 2022 07:17 PM
Jan 19 2022 07:17 PM
Jan 19 2022 09:51 PM
@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.
Jan 20 2022 07:47 PM - edited Jan 20 2022 08:20 PM
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
Jan 20 2022 10:09 PM
Jan 20 2022 10:33 PM
@Shanae1180 As you have noticed, circular references don't work. So yes, it messes up things. Can you give an example with real numbers?
For instance, number of portions = 45 in C6 and the total batch weighs 1000 in A2, then the formula for weight per portion in C2 would be =A2/C6, returning a value of 22,22222.
Now I don't know how you would calculate potion and batch potency is in this context. But I guess, you know. Enter the formulae as the one above, but do NOT include the reference of the cell where you write the formula. Attached a file based on your example.
Jan 20 2022 11:31 PM - edited Jan 20 2022 11:36 PM
Thank you for going through that with me. Can you look at this example that she gave me and see if what you suggested will work?
Jan 21 2022 01:51 AM - edited Jan 21 2022 01:53 AM
But all I can see are the results, I don’t see the formulas. I want to be able to adjust the information and get different dosages.
Like she’s doing in the beginning of this link
But for cbd
All I see in what you sent me is this...
Jan 21 2022 02:00 AM - edited Jan 21 2022 02:02 AM
@Shanae1180 Click on a cell and look in the formula bar. That's where you can see the formula. In the picture below I clicked on C5. Same principle for all the other cells with something in it. And it works the same on a mobile device, though the screen looks different.
Jan 21 2022 02:43 AM