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 that cell it will automatically multiply by the set value and you will see the sum appear in that cell.
Appreciate any help Thanks in advance
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
