<div>
<div class="content wysiwyg-content">
In and formula, how I say: if the 4th character from the left of whatever is in column A is an &quot;R&quot;, put the word &quot;Radius&quot; in the cell. &nbsp;Formula is going in same row column E.<br />
<br />
The false side of the statement is if the 4th character is a &quot;S&quot; put &quot;Square&quot; in the cell.<br />
If neither put a blank.<br />
<br />
I am terrible with if statements..
</div>
</div>


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

Formula if statement.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.