@if(h3="soft";1;0) This is a valid Lotus123 formula. How does Excel interpret = where equals refers to text rather than to a number? This formula reads "if what is in h3 is the (equals) word "soft" then this formula equals 1 (true), otherwise it equals 0 (false). Thanks.