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

Hi

=if(a1=1,"10 Year Amortization","15 Year Amortization")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"bg19299 via OfficeKB.com" escreveu:

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

Thanks for the reply but this does not work within the header. When I type in
an if statement all it does is put the text in the header as opposed to it
calculating the if statement.

Marcelo wrote:
Hi

=if(a1=1,"10 Year Amortization","15 Year Amortization")

hth
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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").text
End With
End Sub

Better yet...............

Place the code in a BeforePrint event.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Text
End With
End Sub

Right-click on the Excel Icon left of "File" on the menubar.

Select "View Code"

Copy/paste the BeforePrint code above into that module.


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 13:44:21 GMT, "bg19299 via OfficeKB.com" <u24604@uwe wrote:

Thanks for the reply but this does not work within the header. When I type in
an if statement all it does is put the text in the header as opposed to it
calculating the if statement.

Marcelo wrote:
Hi

=if(a1=1,"10 Year Amortization","15 Year Amortization")

hth
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.

Gord Dibben MS Excel MVP