Forum Discussion
Help with finishing these formulas please!
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.
- 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.
