Helping Adding Values

[libra22ali]

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

[#2]

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"

[#3]

@Bennadeau Thank you I will give it a try