Hi Chris,

the cell a23 is formated to show Monday but its result is 2 try to use

=if(a23=2,"CREW","")

hope this helps
reagards from Brazil
Marcelo

"Chris" escreveu:

I am trying to make a formula read from a cell that contains a formula. Does
anyone know how to make the subsequent formula read a result rather than the
formula. Here's an example of the formula.
=IF(A23="Monday","CREW"," ")

Cell A23 has the formula =A27 that is formatted to return day of the week
from another cell that has a date 7/3/06. Which returns Monday on the
worksheet. I believe the formula is seeing =A27 instead of the result
Monday, and this is why the if statement is false. Any Ideas????