I want to take the value under (100s you won, value) divide the cell by 100, and display the answer in the (100s you won, number) cell. How should I go about this without having the “/100”?
I want to take the value under (100s you won, value) divide the cell by 100, and display the answer in the (100s you won, number) cell. How should I go about this without having the “/100”?
If you are pulling all those numbers from a graph, can you make make a new function that calculates that ratio in the same graph? Then in your CL, you can just make a variable like you did for the others and send it to row 1, column 2.