Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 29th 15, 05:39 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2015
Posts: 1
Question 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   Report Post  
Old 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
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
how do I set up an escalating number (EG) invoice number tg Excel Discussion (Misc queries) 1 September 2nd 06 06:44 AM
Formula expected end of statement error, typing formula into cell as part of VBA macro [email protected] Excel Programming 1 July 20th 06 07:58 PM
Income Tax Payable from table with escalating marginal percentage rates. Bosko Excel Worksheet Functions 5 November 4th 05 09:20 AM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM


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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017