Function to return text string

  • Thread starter Thread starter PRTCnews
  • Start date Start date
P

PRTCnews

I am knew to Excel's worksheet functions. Is there a function or command I
can place inside the IF function that will return a desired string of text?
For example:
IF(0<=A1<=90, "enter NORTH-EAST in cell K1", "enter OUT OF BOUNDS in cell
L1").
I will greatly appreciate any suggestions. Thanks in advance. RGP.
 
IF(AND(A1>=0,A1<=90), "enter NORTH-EAST in cell K1", "enter OUT OF BOUNDS in
cell L1")

IF((A1>=0)*(A1<=90), "enter NORTH-EAST in cell K1", "enter OUT OF BOUNDS in
cell L1")
 
Back
Top