LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default If formula in header

Is it possible to have a header look at a cell to determine what it should
say? I am currently doing two scenarios in my excel file. When a cell in a
different tab says "1" I want the header to say "10 Year Amortization",
otherwise I want it to say "15 Year Amortization". There will also be text
above the 10 or 15 Year amortization line which is consistent for the two
scenarios. Is this possible? Thanks in advance.

--
Message posted via http://www.officekb.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set a date formula in the page setup header to add 10 phil@work Excel Discussion (Misc queries) 3 June 15th 06 03:47 PM
Custom Header with Formula Randy Excel Discussion (Misc queries) 6 June 15th 06 12:14 PM
Can you put a formula in a header? bozrdang Excel Discussion (Misc queries) 8 May 16th 06 03:46 AM
How do I pull the column header next to a Max formula? mconway Excel Worksheet Functions 2 May 10th 06 05:08 AM
Display result of formula in header? Hubitron2000 Excel Discussion (Misc queries) 2 March 24th 06 07:25 PM


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"