Solved

Formula if statement.

Posted on 2014-04-07
2
141 Views
Last Modified: 2014-04-07
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
Comment
Question by:RWayneH
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39983076
Try:

=IF(MID(A2,4,1)="R","Radius",IF(MID(A2,4,1)="s","Square",""))
0
 

Author Closing Comment

by:RWayneH
ID: 39983116
Thanks worked fine.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question