I'm going to try to write what I am trying to accomplish first in English. I have a formula but something is wrong because it uses the wrong calculation.

I need a formula to check two different cells. If the numbers in those two cells are between 10 and 48 (inclusive) then it is to perform one calculation, if it is outside those then it should perform a slightly different calculation.

Here is what I have:

=IF(AND(F7=MEDIAN(10-48),G7=MEDIAN(10-48)),F5/B8,F5/B8*2)

But when I have numbers that fall in those ranges it is still giving me the false return which is basically double.

I hope that make sense and I'm sure I'm just missing something really simple. I've only recently forayed into using more complex formulas.