Forum Discussion
Help with finishing these formulas please!
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.
- Sorry if this is a silly question, but I’m not very good at this stuff, is that something that I need to change because it will mess up my equation or it is okay?
I’m trying to get the outcome of how much oil to use. I would like my formulas to do the math for me.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.
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?