I would like to create a formula that takes into consideration another cells value. Right now I have =IF(D2=B2,"P",D2-B2) In cell E2. What I want is when cell D2 is the value 0 I want E2 to be blank. When cell D2 has a value other than 0 I want the calculation to show as it should. So when D2 = B2 "P" will show. When D2 is the value 0 then E2 should be blank. Hope this makes sense.
Thanks
Brian
Thanks
Brian