Forum Discussion
Create excel formula to calculate price
Hi, I need to create excel formula to calculate product price. I have numbers in columns and rows. Formula is Width X Height /1400 X unit price. I have Width in 1 columns and Height in 1 row. I would...
Hi,
If unit price is in A1, in C5 formula could be
=C$4*$B5*$A$1/1400
drag it down and to the right.
Demo is in attached
Hello Sergei, thanks for reply. That's what I need. I don't know much about Excel but I will try and hope it works.