Home » Forums » Open Source Learning Center » Question and Answer

Excel formulas or macros

Submitted by cacurran70 on 3 November, 2015 - 13:43

I have 2 columns of text that I want to covert or show in a new column as a number. ss A would = 17, SI A = 18 and SF = 0 how would I do that?

ss A
ss A
si C
sf I
ss A
si C
ss C

AttachmentSize
Book1.xlsx9.4 KB
‹ Please help, I'm getting my butt kicked :) Multiple html pages automatically generate from one excel spreadsheet ›
»

Hi, This can be done by a

Submitted by Cheetahke on 5 November, 2015 - 17:34.

Hi,

This can be done by a formula. If the text is in column A and starts at the first row, you can use something like this:

=if(A1="ss A",17,if(A1="si C",18,if(A1="sf I",0,"")))

»