Hi
I am trying to do a nested if statement that shows the following:
value under 12 = 1097
value between 12 & 24 = 643
value 24 & 36 = 97
value above 36 = 0

this is the formula I tried.
=IF(G23<12,1097,IF(G23<24>12,643,IF(G23<36>24,97,IF(G23>36,0))))

The first two arguments work but the second two return an incorrect value ie if the value is 12 = 1097 and is correct, 23 = 643 and is correct, 34 = 643 and is incorrect, 38 = 643 and is incorrect.

Does anyone have any ideas why?

thanks