Hi,
I need help with creating a formula please. I have 2 columns.
Column A and Column B.
Column A is where I want to have a value, column B will be a decimal number 0.1;0.2 up to 1.0
I want Column A to display a figure based on what that decimal number is.
e.g. of the number is 1.0 Column A will display 500. If it's 0.5 then it will display 250. If it's 0.1 it will display 50. Like a percentage.
Is that possible?
thanks.
Bookmarks