Helping Adding Values

%3CLINGO-SUB%20id%3D%22lingo-sub-1620212%22%20slang%3D%22en-US%22%3EHelping%20Adding%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620212%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20someone%20could%20please%20help%20me%20I%20am%20trying%20to%20create%20a%20formula%20for%20a%20column%20in%20my%20spreadsheet%20for%20a%20specific%20value%20example%201.20%20to%20always%20be%20there%20and%20that%20when%20you%20enter%20example%202%20in%20that%20cell%20it%20will%20automatically%20multiply%20by%20the%20set%20value%20and%20you%20will%20see%20the%20sum%20appear%20in%20that%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20any%20help%20Thanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1620212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1621035%22%20slang%3D%22en-US%22%3ERe%3A%20Helping%20Adding%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621035%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F775155%22%20target%3D%22_blank%22%3E%40libra22ali%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20want%20will%20require%20a%20macro.%3C%2FP%3E%3CP%3EAnother%20approach%20is%20to%20use%20two%20columns%20like%20in%20this%20example.%3C%2FP%3E%3CP%3EColumn%20A%20is%20where%20you%20input%20your%20data%20while%20column%20B%20will%20multiple%20whatever%20you%20input%20in%20A%20by%201.2.%20If%20there%20is%20no%20data%20in%20column%20A%2C%20column%20B%20will%20display%20%221.2%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1598731019206.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215395iF4FB65666D24E5AF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1598731019206.png%22%20alt%3D%22Bennadeau_0-1598731019206.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1627838%22%20slang%3D%22en-US%22%3ERe%3A%20Helping%20Adding%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3BThank%20you%20I%20will%20give%20it%20a%20try%3C%2FP%3E%3C%2FLINGO-BODY%3E
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_0-1598731019206.png

 

@Bennadeau Thank you I will give it a try