Change "FALSE" to "NO DATA"

  • Thread starter Thread starter AAA1986
  • Start date Start date
A

AAA1986

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.
 
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.
Click to expand...

=IF(P18="PMR",E$26,"NO DATA")
 
Back
Top