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'
 
Back
Top