If function not working (macro)

[mrgrape]

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

[Kaper]

=IF(H486>7.99,0.33,0.17)

and copy down or

=IF(or(H486>7.99,H487>7.99,H488>7.99,H489>7.99),0.33,0.17)

[mrgrape]

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!

[mrgrape]

Sorry....greater than 7.99

[mrgrape]

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

[jason.b75]

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.

[mrgrape]

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

[jason.b75]

....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.