Jan 15 2019 01:39 PM
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
Jan 15 2019 02:19 PM
It could be
=25+12.5*INT(A1/1000)