If function not working (macro)

Hello all,

So I have formulated an "IF" function as per below:

=IF(H486:H489>7.99,0.33,0.17)

But when I apply it to the following table, it's not returning the desired value....what could be the cause of this? Thank you in advance.

Capture.JPG

Thank you so much for your response Kaper!

What i am trying to achieve, is if the sum of 4 rows combined is greater than 8, then the 0.33, if not, then 0.17.

Thank you!

Sorry....greater than 7.99

Please note that there is a 1 as well in h486.

Originally Posted by mrgrape

is if the sum of 4 rows combined is greater than 8

Looking at your comment quoted above, and your original formula, =IF(H486:H489>7.99,0.33,0.17) the problem becomes clear.

=IF(SUM(H486:H489)>7.99,0.33,0.17)

Without a function specified, only the cell in the same row as the formula is used, the other 3 are ignored.

Thank you so much! That was the problem....how could I have overlooked that. Again, thank you so much!

Originally Posted by mrgrape

....how could I have overlooked that.

You would be surprised how often similar questions appear on the forum, the simplest mistakes are often the hardest to see.