Hi,
I am trying to come up with a formula that does a couple of sums from cells, and if its more than .26 or less than -.26 displays one thing and anything in the middle displays another. This is my attempt but I can't see quite what is wrong with it. Any help would be greatly appreciated.
IF(AND(IF(K2="Home",AA2-AB2+L2,AB2-AA2+L2)>0.25,(IF(K2="Home",AA2-AB2+L2,AB2-AA2+L2)<-.25,"full","void")))
I am trying to come up with a formula that does a couple of sums from cells, and if its more than .26 or less than -.26 displays one thing and anything in the middle displays another. This is my attempt but I can't see quite what is wrong with it. Any help would be greatly appreciated.
IF(AND(IF(K2="Home",AA2-AB2+L2,AB2-AA2+L2)>0.25,(IF(K2="Home",AA2-AB2+L2,AB2-AA2+L2)<-.25,"full","void")))