How do I make a formula read a result rather than a formula
 

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????

How do I make a formula read a result rather than a formula
 

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????

How do I make a formula read a result rather than a formula
 

I suspect that test isn't seeing the formula, but rather the value that Excel
uses to represent the date 7/3/06. If you're showing Monday by formatting a
date value, the VALUE hasn't changed, so the test will fail. You should
either change the value to be the weekday =text(a27,"dddd") in cell A23, or
test for the appropriate weekday within the if function:
=if(weekday(a23,1)=2,"CREW", " ")

"Chris" wrote:

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????

How do I make a formula read a result rather than a formula
 

try
=IF(WEEKDAY(A23)=2,"crew","")

"Chris" wrote:

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????

How do I make a formula read a result rather than a formula
 

Try using weekday instead of Monday

=IF(WEEKDAY(A23)=2,"CREW"," ")


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553794

How do I make a formula read a result rather than a formula
 

Thanks, this worked great! Now, how would I write it if I needed multiple IF
statements? For example if the result was a Tuesday instead?

Chris

"Nikki" wrote:

try
=IF(WEEKDAY(A23)=2,"crew","")

"Chris" wrote:

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????

How do I make a formula read a result rather than a formula
 

Not sure what your criteria is so replaced with day of week

=IF(WEEKDAY(A23)=6,"Saturday",IF(WEEKDAY(A23)=7,"S unday",IF(WEEKDAY(A23)=1,"Monday",IF(WEEKDAY(A23)= 2,"Tuesday",IF(WEEKDAY(A23)=3,"Wednesday",IF(WEEKD AY(A23)=4,"Thursday",IF(WEEKDAY(A23)=5,"Friday","" )))))))


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553794

How do I make a formula read a result rather than a formula
 

or

=CHOOSE(WEEKDAY(A23),"Saturday","Monday", "Tuesday", "Wednesday",
"Thursday", "Friday","Sunday")

Change Days to your text


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553794