conditional headings
Assume the user enters a value between 1 and 12 inclusive into cell
A1. You could use this in another cell to return your heading:
=CHOOSE(A1,"One","Two","Three","Four","Five","Six" ,"Seven","Eight","Nine","Ten","Eleven","Twelve" )
Of course, you should substitute the headings you want for the
"numbers".
Hope this helps.
Pete
On Jan 11, 7:00*pm, excel help acct <excel help
wrote:
I need to populate a heading on an excel spreadsheet based on a value keyed
by a user. *It can be one of 12 values keyed in. *How can I code the heading
to appear based on the chouice selected by the user?
|