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