Please go to the Tab Labeled "Range of Percentage Fees"
So I thought I had this working yesterday, but when I came back today this formula didn't want to work, consistently returning the value of 11. But basically what I'm trying to do is get this formula to return a value number as represented in the Cells C3:X3, of 1-11. For Construction Costs that Range, as representing in Cells C4:X4.
These values are derived based on projected Building Costs, Cell F32.
But the Basic Functionality is as follows:
For a Construction Value that is Greater Than or Equal to 0, but Less than 500,000 return a Value of 1.
For a Construction value that is Greater Than or Equal to 500,000, but Less than 1,000,000 Return 2.
Etc.
But or some reason regardless of the Construction Value listed in F32, it keeps reporting 11, although this worked yesterday before I left for home.
Solved by G. H. in 19 mins