doing formulas

Occasional Contributor

i have a problem 






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