Im trying to create a grid formatted pricelist and i want to add either a percentage markup or a fixed amount whatever is greater
What formula do i use?
Im trying to create a grid formatted pricelist and i want to add either a percentage markup or a fixed amount whatever is greater
What formula do i use?
=MAX((1+pct mrkup)*value,value+fixed amount)
If this isnt what you're looking forward, it would be better if you attached a sample file (please read the yellow banner at the top of this page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks