Characters in logical calculations

A

alex3867

I am trying to create the formula which interprets 'y' as 'YES' and 'n
as 'NO' in a set of seperate cells (i.e one column has y's and n's
converted to YES's and No's in another column)

I have tried the IF function, but even with no character (y or n) i
the first column, NO is still shown in the second.

Ideally I need a discrete formula that shows only YES or NO only if
or n is present.

Any ideas?

Thanks in advance
Ale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula help 2
Finding the sum/ average of non numerical values? 2
Formula for Multiple "IF's" or maybe "COUNTIF's"??? 7
whats the formula 2
Conditional Formatting - Row colour 4
How to do calculations with Null in the column? 4
Count the Y's in a filtered column that contains Y and N 1
COUNTIF between dates and if value = "y" 8

Top