Forum Discussion
Helping Adding Values
Good day! If someone could please help me I am trying to create a formula for a column in my spreadsheet for a specific value example 1.20 to always be there and that when you enter example 2 in ...
Hi libra22ali,
What you want will require a macro.
Another approach is to use two columns like in this example.
Column A is where you input your data while column B will multiple whatever you input in A by 1.2. If there is no data in column A, column B will display "1.2"
Bennadeau Thank you I will give it a try