Pricing Calculator

July 27, 2016

0 comments

calculator   excel tricks   Excelskin   Mac Excel Shortcuts   mac shortcuts for excel   Mastering Excel   Microsoft Excel   Microsoft Excel for Mac   pricing calculator  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Microsoft Excel provides the perfect platform for an on-demand pricing calculator.  Instead of fumbling with your calculator while you're on the phone with a prospect, I will show you how to create a pricing chart that automatically adjusts all possible options based on just a few cells. 

In this example I will assume we are charging on a per-seat basis, similar to most SaaS companies.

List price will be $50/core seat, and $25/ lite seat, but I am willing to discount up to 20% off.  I will setup my spreadsheet so that all I have to do is adjust the number of seats, and the rest will be calculated for me. 

Here is my simple price calculator.  The only thing I have to change on each of my calls is the seat number, and the Totals per Month will automatically re-calculate.

Now, lets reveal the formulas in each cell.

 

The Standard pricing formula is straight forward.  All it is doing is multiple the number of Core Seats by $50, the number of Lite Seats by $25, and adding the two numbers together.

The discounted pricing formulas do the same thing, but they first calculate the discount and then subtract that from the Standard Pricing row.  

There are a few different ways to accomplish this calculation so feel free to play with the formulas as needed.  

And there you have it! A complete pricing calculator that only needs you to change the seat numbers to update completely.  You can set this up for unlimited possibilities in discounts or upsells to save you time and money in the future.

As always, let us know if you have any questions!  

 



Leave a comment

Comments will be approved before showing up.