I am trying to build a generic spreadsheet for calculating costs. Some of my materials are sold by pounds per lineal foot and some by the square foot. I have attached an Excel 2010 spreadsheet with my layout. I am having a problem getting my price formula to work. I would like to be able to use the same formulas whether selling by the SFT or LFT so the formula for each Line Item doesn't have to be changed each time a different item is placed in the spreadsheet.
Hi
In G11
=H11*O11*MAX(P11,Q11)*R11
--
Regards
Roger Govier
Microsoft Excel MVP
Roger,
Thank you so much for your assistance. This will be so much easier than modifying the formula each time I change materials.
Dobee,
before posting any further please read forum rules especially about thread titles.Thx
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks