I am trying to type an IFS statement that will look at one cell and decide on the answer based on a greater or lesser than decision.
10 sq. in. or below = $7.00
10 - 25 sq. in. = $10.00
25 - 50 sq. in. = $14.00
50 - 75 sq. in. = $17.00
75 - 100 sq. in.= $20.00
100 - 150 sq. in.= $23.00
150 -...