Excel formula conditional upon another cell value

[Harry]

Hello

This should be easy. I want to set the value of a certain cell to the value of another, if the value of a third cell =
Y. So, I went

=IF(K171=Y,K198)

It gives me an error, telling me to enter a valid number.

Anyone see the error.

Thank you

Harry

 

[Bob Phillips]

What is Y? You can test for a value (1, "a", etc), a cell ref (Y10, AZ7,
etc.), or a named range (any name referring to a cell).

--

HTH

RP
(remove nothere from the email address if mailing direct)

Hello

This should be easy. I want to set the value of a certain cell to the

value of another, if the value of a third cell =