Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula conditional upon another cell value
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) "Harry" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format if cell contains formula | Excel Worksheet Functions | |||
how to conditional format a cell if the cell contains a formula (U | Excel Worksheet Functions | |||
conditional formatting a cell that has a formula | Excel Worksheet Functions | |||
conditional cell formula | Excel Discussion (Misc queries) | |||
Conditional formatting in a cell formula | Excel Programming |