Why is a simple division formula not working?
I am trying to divide two different cells into another cell.
I am taking my information from my quantity column (qty3) and my rate column (rate3) and divide them.
I want it to look like this =QTY3/RATE3 but it always comes up #INVALID OPERATION.
I also changed the symbol to addition and it did not add the numbers correctly, so I do not know what to do.
Help Article Resources
Check out the Formula Handbook template!