Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value instead of formula?
Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30) Q5: = B9 formatted as date 01/05/09 N5: = Q5 formatted as day Monday G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","") ('ADIMOOLAH,RILEY'!R$7)= Monday G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am assuming that it has something to do with looking at the formula in N5 instead of the result of the formula. Other cells will be looking for a match with "Wednesday", others, "Friday". How do I get this to work? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |