Formula if statement.

In and formula, how I say: if the 4th character from the left of whatever is in column A is an "R", put the word "Radius" in the cell.  Formula is going in same row column E.

The false side of the statement is if the 4th character is a "S" put "Square" in the cell.
If neither put a blank.

I am terrible with if statements..
RWayneHAsked:
Who is Participating?
 
NBVCCommented:
Try:

=IF(MID(A2,4,1)="R","Radius",IF(MID(A2,4,1)="s","Square",""))
0
 
RWayneHAuthor Commented:
Thanks worked fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.