Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
I have an IF formula that returns " " when logic is TRUE, but I wish it to
return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
Is the column heading in a cell? Is so, just have the false logic be the
cell with the header in. "NN" wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
Post the formula you have.
-- Brevity is the soul of wit. "NN" wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
Is the column heading just a cell where you've typed the header?
If yes: =if(something,"",A1) Where A1 holds that header. NN wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
The formula I currently have is
=IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0," ","Due") I wish to replace the word "Due" with whichever column heading is the result. "Dave Peterson" wrote: Is the column heading just a cell where you've typed the header? If yes: =if(something,"",A1) Where A1 holds that header. NN wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
I don't see anything that describes how the result is obtained.
NN wrote: The formula I currently have is =IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0," ","Due") I wish to replace the word "Due" with whichever column heading is the result. "Dave Peterson" wrote: Is the column heading just a cell where you've typed the header? If yes: =if(something,"",A1) Where A1 holds that header. NN wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
The formula determines if any of the dates in the range of H2:U2 are between
the dates in cells E2 and F2, and if not the cell remains blank. If there is a date in that range that is between the dates in E2 and F2 the cell is given the word Due. Rather than the word Due, I want an equation that will find the date and then return to the cell the column header of that cell. "Dave Peterson" wrote: I don't see anything that describes how the result is obtained. NN wrote: The formula I currently have is =IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0," ","Due") I wish to replace the word "Due" with whichever column heading is the result. "Dave Peterson" wrote: Is the column heading just a cell where you've typed the header? If yes: =if(something,"",A1) Where A1 holds that header. NN wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have an IF formula to return column heading for FALSE
Assuming the headers are in H1:U1, how about:
=IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0,"", INDEX(H1:U1,MATCH(1,(H2:U2=E2)*(H2:U2<=F2),0))) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) ps. I changed your " " to "", too. I also included the end dates with = and <=. Did you want them included? NN wrote: The formula determines if any of the dates in the range of H2:U2 are between the dates in cells E2 and F2, and if not the cell remains blank. If there is a date in that range that is between the dates in E2 and F2 the cell is given the word Due. Rather than the word Due, I want an equation that will find the date and then return to the cell the column header of that cell. "Dave Peterson" wrote: I don't see anything that describes how the result is obtained. NN wrote: The formula I currently have is =IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0," ","Due") I wish to replace the word "Due" with whichever column heading is the result. "Dave Peterson" wrote: Is the column heading just a cell where you've typed the header? If yes: =if(something,"",A1) Where A1 holds that header. NN wrote: I have an IF formula that returns " " when logic is TRUE, but I wish it to return the column heading for the FALSE logic. What is the formula for the FALSE logic, please? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formulas | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |