Home

Create excel formula to calculate price

rogb2
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
Highlighted

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies