A
andrew
I have the following formula:
=IF((AND(ISNUMBER(T7),N7="H",T7=0)),"x",(IF(AND(ISNUMBER(T7),N7="H",T7<>0),"R","")))
The formula above is able to provide a result, but I keep getting the
'triangle tab' on the top left of the cell saying that this is inconsistent.
Due to this, it has also affected my other formula cells - some which
returned "Value Not Available" error.
Any ideas?
=IF((AND(ISNUMBER(T7),N7="H",T7=0)),"x",(IF(AND(ISNUMBER(T7),N7="H",T7<>0),"R","")))
The formula above is able to provide a result, but I keep getting the
'triangle tab' on the top left of the cell saying that this is inconsistent.
Due to this, it has also affected my other formula cells - some which
returned "Value Not Available" error.
Any ideas?