• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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..
0
RWayneH
Asked:
RWayneH
1 Solution
 
NBVCCommented:
Try:

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

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now