Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Creating an Excel Freight Calculator

Hi Elisa,

Am Wed, 6 Jun 2012 16:56:36 +0000 schrieb Elissa:

Freight Rates Percentage
$0.00 - $10,000.00 2.00%
$10,001.00 - $50,000.00 1.50%
$50,001.00 - $400,000.00 0.50%

your price in A1, then your price plus percentage:
=A1*VLOOKUP(A1,{0,1.02;10001,1.015;50001,1.005},2, 1)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a calculator	bearing man	Excel Discussion (Misc queries)	1	December 15th 09 04:13 PM
freight calculator	pturnernz	Excel Discussion (Misc queries)	0	September 12th 08 01:52 AM
creating a calculator	mmacnz	Excel Discussion (Misc queries)	1	October 23rd 07 04:07 PM
Creating a Utility Cost calculator	Eric	Excel Discussion (Misc queries)	1	September 9th 06 05:11 AM
Integrated calculator in excel 07 instead of separate calculator	Wayne	Excel Programming	1	July 26th 06 04:16 PM

All times are GMT +1. The time now is 10:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us