Remember Me?

#1
January 29th 15, 05:39 PM
 Junior Member First recorded activity by ExcelBanter: Jan 2015 Posts: 1
Escalating Formula

I am in the landscaping industry and have a long, complicated spreadsheet for calculating estimates and was hoping to find an answer for a formula to calculate escalating costs, for example (numbers are not actual):

for a lawn fertilization it is \$50 for a 4,000 sq ft lawn, \$53 for a 5,000 sq ft, \$55 for 6,000, \$58 for 7,000, etc. etc. etc.

I used to use a flat rate cost per 1,000 sq ft but when you get to large properties the cost is so high and unwarranted given the efficiency factor i.e. cost per 1,000 sq ft should be lower for large properties to make it fair and competitive.

Any recommendations???

#2
January 29th 15, 06:28 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,872
Escalating Formula

Hi Jon,

Am Thu, 29 Jan 2015 17:39:04 +0000 schrieb jonstap:

for a lawn fertilization it is \$50 for a 4,000 sq ft lawn, \$53 for a
5,000 sq ft, \$55 for 6,000, \$58 for 7,000, etc. etc. etc.

make a list e.g. from L1 to M15:
0 40
1000 43
2000 45
3000 47
4000 50
5000 53

If the areas are in A1 use this formula to get the cost:
=VLOOKUP(A1,\$L\$1:\$M\$15,2,1)

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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

 Similar Threads Thread Thread Starter Forum Replies Last Post PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM tg Excel Discussion (Misc queries) 1 September 2nd 06 06:44 AM [email protected] Excel Programming 1 July 20th 06 07:58 PM Bosko Excel Worksheet Functions 5 November 4th 05 09:20 AM Muxer Excel Programming 2 July 24th 03 01:02 AM

All times are GMT +1. The time now is 02:17 PM.