Define formula

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

=IF(ISBLANK(AB7)=TRUE,"Unsolicited","Solicited")


Cell AB7 is a RFA/PA # example: (PA00-069)


I need to understand what this formula means
any advise
 
If there is nothing in AB7 (that is, AB7 is empty), you get Unsolicited in
the formula cell, otherwise Solicited.
 
Hi
this formula just tests if cell AB7 is empty (blank). If it is blank it
returns the word 'Unsolocited' in all other cases (something is entered
in cell AB7) this formula returns 'Solicited'
 

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

Need advice on my sumif formula (text ref.) 2
Copy a formula pattern 2
Formulas that refer to a cell in the last row 3
Formula to return value from multiple sheets if volume matched 2
If formula maxed out to 7, but need 1 more. Help ??? 1
Need help with my formula please 4
More syntax headaches 2
find text in a string formula 5

Back
Top