Help needed with Excel formula using "IF" "AND"

[Michigan1100]

I am trying to create a formula that will do the following;

IF H2 is greater than 50% of I2+JK+K2 then return "***"
I am using the following formula but it is not working correctly
=IF(AND(H2>+I2+J2+K2/2),"***")
Any ideas on what I am doing wrong or how to make this work correctly? Thanks for any pointers!!!

 

[silentwolf]

Hi,
=IF(H2>SUM(I2:K2)/2,"***")

that gives you the "***" back when it is true if it is not true then it returns FALSE

HTH

 

[Michigan1100]

YES, that did it Thank you very much!!!
Really appreciate the help!

 

[DanteAmor]

The detail is in the parentheses, you must first do the sum and then the division

=IF(H2>(J2+K2+L2)*0.5,"***","It is not greater")

 

[silentwolf]

No Problem )

Cheers