Helping Adding Values

New Contributor

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 Replies

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