for Example If I want to check if A1=B1
=if(A1=B1,L5+E6-J56,"")

"freebee" wrote:

Hi, I'd like to know how to set a formula in "value if true". I want to get
sum of L5+e6-J56 when the value is true

Thanks.