Help with "If" function?
Thanks Gary.
"Gary Keramidas" wrote:
use the formula to create the result. then use conditional formatting to format
that cell based on the result.
--
Gary
"exceltyro" wrote in message
...
I have a related question. How to print the evaluated results from an "IF"
function in different font colors for the two choices??
"mel" wrote:
The following syntax results in either Yes or No being displayed in the cell
depending on whether or not the value is 55. =IF(A2=55,"Yes", "No")
How can program the cell to display one of several results depending on the
value entered in cell A2?
For example:
If A2 is 55, A1 should display ABCDEFG
If A2 is 56, A1 should display HIJKLMOP
If A2 is 57, A1 should display QRSTUV
|