I am trying to obtain a formula that gives a dollar value based on the amount of sq ft.

$10 for each 2000 square feet of area, but not less than $130


For example, the minimum is 2000 square feet, which would be $130


So if I were to input 9000 square feet, I would get $170


Any help would be greatly appreciated.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

My apologies. I edited the title of the thread. Hopefully this makes things a little clearer.

I would use:

Formula:

Please Login or Register  to view this content.

But it returns 165 (not 170) for 9000.

2000 = 130
How much is 4000?

If 10 for each 2000 then it would be for me 140.
If we go with same logic then 9000 would be 165.

4000 would equal out to $140, and 9000 square feet would be $165, correct. Thank you so much!