| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value instead of formula?
try this
=IF(('ADIMOOLAH,RILEY'!R$7)=Text(N$5,"dddd"),"FLEX ","") On Feb 11, 2:21*am, Gator Girl wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value instead of formula?
Hi,
Use =TEXT(Q5,"dddd") -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gator Girl" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value instead of formula?
Thank you for submitting, I didn't try yours, cause it would have involved a
lot more editing than Shane's suggestions, but I do appreciate your help. "muddan madhu" wrote: try this =IF(('ADIMOOLAH,RILEY'!R$7)=Text(N$5,"dddd"),"FLEX ","") On Feb 11, 2:21 am, Gator Girl wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value instead of formula?
Thank you! works like a charm. :)
"Shane Devenshire" wrote: Hi, Use =TEXT(Q5,"dddd") -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gator Girl" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value instead of formula?
Glad to help, and thanks for the feedback.
Cheers, Shane Devenshire "Gator Girl" wrote: Thank you! works like a charm. :) "Shane Devenshire" wrote: Hi, Use =TEXT(Q5,"dddd") -- If this helps, please click the Yes button Cheers, Shane Devenshire "Gator Girl" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
