I need an if formula

[tlbgto]

I need a formula for the following

If column e= column f answer x
If column e doesn't equal f answer is s, unless column f is p then answer is p.

 

[mikerickson]

Something like

=IF(E1=F1, "x", IF(F1="p", "p", "s"))

 

[Cease]

I have no doubt there's a prettier way, but I would use:

let's say you had the formula in column a:
in A1 use: =if(e1=f1,"x",if(e1=p1,"p","s"))

Should do the trick :D

 

[tlbgto]

Those formulas don't seem to be working a the p is a letter and not a column.

If column e equals column f answer is x
If column e does not equal column f the answer is s, unless column f contains the letter p in which case the answer would be p.

Is a formula possible like that?

 

[Bryman]

That formula should work what row does your data start in ?

 

[Bryman]

Does this work?

=IF(E1=F1,"x",IF(F1="p","p","s"))

 

[tlbgto]

It comes back with an error name. Does not recognize text in a formula. If I enter a number say 15 instead of p it works fine.

 

[tlbgto]

I think I found the problem. It appears that it is in the formatting. On a blank excel it works, but on the data drop it does not. Thanks for all the help.

 

[Bryman]

Yeh, are if you are exporting the report from outside source (ie Oracle Business Object or downloading it from somewhere) it can be a crazy format, I run into that sometimes.