Simple IF formula

[JoelBrown1990]

Hi All,

I know this is probably a simple one but can someone please write me an IF formula for the following scenario:

I would like cell S8 to show the value in R8 if cell N8 has the value "X".

I will then be able to tweak the formula to suit.

Much appreciated in advance.

Many thanks,
Joel

 

[Z51]

Put this in cell S8:

=IF(N8="X",R8,"")

 

[JoelBrown1990]

Put this in cell S8:

=IF(N8="X",R8,"")

Thank you. Worked perfectly.