| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
