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.
 
The below will do what you're looking for. Rgs, Rob

=IF(P18="PMR",E$26,"No Data")
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What reassigns the licence of my Office 2000 suite? 2
Why excel cell color did not change after formatting and VBA code? 7
Change the letter instead of the number 4
vlookup formatting problem 1
Odd Problem with HLOOKUP -- Any change breaks it 5
Excel Help to copy information from one row at a time to another sheet 1
If statement that returns data in a cell if False. 2
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21

Back
Top