Moving Info from Cell to Cell

[GDB]

I am very green when it comes to excel. I can only create very rudimentary functions. Here's what I need to do and require help with.
I would like to enter in two different cells a P or F (pass or fail). I would like this P or F to automatically go into another cell (final cell) with conditions. If both of the cells have a P then the final cell would show a P. If either one of the cells has an F then the final cell would show an F.

If you can be of help I thank you. Too much of my Sunday has been sent trying to figure this out.

 

[shajueasow]

Hi,
Welcome to the board.
Try this by replacing the cells (A1 and B1 to your needed references), and put this in the cell where you need the answer

=IF(AND(A1="p",B1="p"),"P","F")

It is assumed that you are entering values into Cells A1, and B1.

 

[just_jon]

Welcome to MrExcel - one way --

Book1
	A	B	C	D
1	F	P	F
2	P	P	P
3	F	F	F
4
5
Sheet2

In A1 copied down: =IF(OR(B1="F",C1="F"),"F",IF((B1="P")*(C1="P"),"P",""))

 

[GDB]

Thanks to both of the respondents. Both of your replies work. Now I can enjoy the rest of the day! Hope you have a nice day too!