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
|