doing formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2338558%22%20slang%3D%22en-US%22%3Edoing%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338558%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20problem%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPrice%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%2413.92%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%242.52%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%243.00%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EI%20need%20to%20write%20a%20formula%20so%20it%20is%20mulpty%20that%20price%20by%2045%25%26nbsp%3B%20and%20if%20I%20carry%20it%20down%20it%20will%20do%20the%20rest%20of%20it%20in%20that%20colum%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2338558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2338579%22%20slang%3D%22en-US%22%3ERe%3A%20doing%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338579%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022143%22%20target%3D%22_blank%22%3E%40pjakl%3C%2FA%3ESuppose%20the%20first%20price%20is%20in%20A2.%20Enter%20%3CSTRONG%3E%3DA2*45%25%3C%2FSTRONG%3E%20%26nbsp%3Bin%20B2%20and%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339581%22%20slang%3D%22en-US%22%3ERe%3A%20doing%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339581%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bplease%20see%20attached%20file%20as%20it%20does%20not%20seem%20to%20be%20doing%20anything%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i have a problem 

 

Price

$13.92

$2.52

$3.00


I need to write a formula so it is mulpty that price by 45%  and if I carry it down it will do the rest of it in that colum

 

 

 

3 Replies

@pjaklSuppose the first price is in A2. Enter =A2*45%  in B2 and copy it down.

@Riny_van_Eekelen please see attached file as it does not seem to be doing anything

 

 

@pjakl You should enter the formula in B2, not in A2