I will better explain myself: I have 2 cells, A1 with a value of 10 and B1 with a value of 5, then in the cell C1 I have the formula: " =A1*B1". Therefore the value shown in the cell C1 is "50" (=10*5). This is why you use Excel
However inside my formula, I want to do extract the value of cell B1 and keep it only as a value, and maintaining the reference to cell A1. In this way: " =A1*5 "
I want to extract and convert my string inside the formula as a number for the value of cell B1. So in C1 I want to write the formula like this: "=A1*5" .
The result will always be the same but instead of B1 in the formula, I want only its value (and instead I want to keep A1 as it is). As shown in the image below. How can I do it?
I know some of you would probably wonder why I want to do this: the reason is that I have a table with a lot of values and parameters for biological data, and I don't want to keep to much columns on it because it is very very large. So what I want to do, is avoid of having the column with one parameter in my Excel sheet: therefore I want to convert in my formula " =A1*B1 ", the reference to the cell B1 to its own numerical value ---> it would be like this: " =A1*5 "
Is it clear? Please tell me if you need further clarification. I thank everyone who will spend time to read or answer my post. Thank you!
However inside my formula, I want to do extract the value of cell B1 and keep it only as a value, and maintaining the reference to cell A1. In this way: " =A1*5 "
I want to extract and convert my string inside the formula as a number for the value of cell B1. So in C1 I want to write the formula like this: "=A1*5" .
The result will always be the same but instead of B1 in the formula, I want only its value (and instead I want to keep A1 as it is). As shown in the image below. How can I do it?
I know some of you would probably wonder why I want to do this: the reason is that I have a table with a lot of values and parameters for biological data, and I don't want to keep to much columns on it because it is very very large. So what I want to do, is avoid of having the column with one parameter in my Excel sheet: therefore I want to convert in my formula " =A1*B1 ", the reference to the cell B1 to its own numerical value ---> it would be like this: " =A1*5 "
Is it clear? Please tell me if you need further clarification. I thank everyone who will spend time to read or answer my post. Thank you!