ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IF formula to return column heading for False logic (https://www.excelbanter.com/excel-discussion-misc-queries/112898-if-formula-return-column-heading-false-logic.html)

NN

IF formula to return column heading for False logic
 
I have my IF formula returning " " when the logic is True and now wish the
column heading to be returned if the logic is False. What is the final
formula for this part of the IF formula, please?

Pete_UK

IF formula to return column heading for False logic
 
Post a copy of your formula and someone might be able to suggest an
answer. By "column heading", do you mean the column letter, so that if
the formula is in column C it would return "C"?

Pete

NN wrote:
I have my IF formula returning " " when the logic is True and now wish the
column heading to be returned if the logic is False. What is the final
formula for this part of the IF formula, please?




All times are GMT +1. The time now is 08:37 PM.

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