Change "FALSE" to "NO DATA"
=IF(P18="PMR",E$26,"NO DATA")
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"AAA1986" wrote:
Right now I have the following function in a cell column:
=IF(P18="PMR",E$26)
But when the referenced cell does not equal "PMR" it turns up as "FALSE".
Can I change this so it turns up as "NO DATA"?
Thanks in advance.
|