Create excel formula to calculate price

New Contributor

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 like to create formula that would automatically calculate and put price in each cell. All I want to do is enter unit price and formula should do the calculations and put price in each cell. Price should be whole number like 50 or 60 not 50.5332 etc. I am attaching excel sheet to work on.  

2 Replies



If unit price is in A1, in C5 formula could be


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.

Related Conversations
Excel behaving strangely
Torben165 in Excel on
0 Replies
facing issue to pull data from particular website
NitinJau in Excel on
0 Replies
kaatje77 in Excel on
2 Replies
Custom Sort Alphabet Alphabetizing
jonahw218 in Excel on
3 Replies
Round Down to the nearest 5
jshea23 in Excel on
1 Replies
help with formulae
Gavc1 in Excel on
1 Replies