Home

Need formula on excel to calculate permit fee

%3CLINGO-SUB%20id%3D%22lingo-sub-316384%22%20slang%3D%22en-US%22%3ENeed%20formula%20on%20excel%20to%20calculate%20permit%20fee%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-316384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20create%20a%20spread%20sheet%20to%20use%20for%20pricing%20permits.%3C%2FP%3E%3CP%3Ethe%20way%20pricing%20works%20is%3A%3C%2FP%3E%3CP%3EAny%20structure%201000%20sqft%20and%20under%20is%20%2425.00%3C%2FP%3E%3CP%3Efor%20each%201000%20sqft%20or%20fraction%20thereof%20more%20it%20is%20%2412.50%20per%201000%20sqft%26nbsp%3B%3C%2FP%3E%3CP%3Eive%20been%20trying%20different%20ways%20to%20do%20it%20but%20I%20cant%20figure%20it%20out%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-316384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebracket%20pricing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPricing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprogressive%20pricing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-316916%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20formula%20on%20excel%20to%20calculate%20permit%20fee%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-316916%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3D25%2B12.5*INT(A1%2F1000)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
carllkerley
Occasional Visitor

Hi, I am trying to create a spread sheet to use for pricing permits.

the way pricing works is:

Any structure 1000 sqft and under is $25.00

for each 1000 sqft or fraction thereof more it is $12.50 per 1000 sqft 

ive been trying different ways to do it but I cant figure it out

1 Reply

It could be

=25+12.5*INT(A1/1000)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies