As an addendum to my earlier post, if the 'Inside' result is supposed to be double the 'Outside' result, then you might be missing some parentheses, as well. Try the following if the efforts above are slightly off:
=IF(AND(F7<=48,F7>=10,G7>=10,G7<=48),F5/B8,F5/(B8*2))
EDIT: Nevermind, having re-read it I see that the 'False' return should be the one that's double.
Bookmarks