View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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