I have written the following formula to calculate the follows:It is wrong. Can someone tell me the correct one? I want to enter a “wrong” if aa14 is not “0”. aa14 may be a -1 etc or 1 or greater. If aa14 is at 0 then I want the cell to read “right”=IF(AA14<>“0”,”wrong”,”right”)
Thank you
Merv
