ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I have an IF formula to return column heading for FALSE (https://www.excelbanter.com/excel-discussion-misc-queries/113004-i-have-if-formula-return-column-heading-false.html)

NN

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?

Office Helper

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?


Dave F

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?


Dave Peterson

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

NN

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


Dave Peterson

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

NN

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


Dave Peterson

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


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com