Formula Help

[Niccalo]

Please excuse my ignorance but would someone mind telling me what I did
wrong to this formula and what I can do to fix it?


=IF C2 = "X" Then E3 = C3, If D2 = "X" Then E3 = D3


Much thanks

 

[Kieran]

A quick literal translation to make it worksheet formula compatible is
=IF( C2 = "X" , E3 = C3, If (D2 = "X" ,E3 = D3))

if neither C2 or D2 is = "X" then E3 will be blank

If you want something in this instance try
=IF( C2 = "X" , E3 = C3, If (D2 = "X" ,E3 = D3, "No X found "))

and change the No X found to whatever you need. (Just "" will give an
empty looking cell)

 

[Niccalo]

Thank you very much!

*A quick literal translation to make it worksheet formula compatible
is
=IF( C2 = "X" , E3 = C3, If (D2 = "X" ,E3 = D3))

if neither C2 or D2 is = "X" then E3 will be blank

If you want something in this instance try
=IF( C2 = "X" , E3 = C3, If (D2 = "X" ,E3 = D3, "No X found "))

and change the No X found to whatever you need. (Just "" will give an
empty looking cell) *

 

[Sandy Mann]

Am I missing something here?

For this formula to put a value in cell E3 then the formula has to be in E3
so shouldn't the formula be:

=IF(C2="X",C3,IF(D2="X",D3,"No X found"))

Of course I may have the wrong end of the stick

Sandy