Function to return text string

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.
 
A

Aladin Akyurek

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")
 

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

Link a text box based on drop down box with four options MS Word 365 0
Need help finding a substring in a array of strings. 1
Function or Sub to help with text string 5
IF function says too many nested 1
Search a range for instances of a text string, return neighboring cell values each ti 2
Is there a function that will evaluate a text string in a cell? 2
Mapping integers to strings 6
how do I create a cell reference from ADDRESS function return? 3

Top