IF with a Sequence to generate numerical text - Stop Incrementing

[WhatTheF]

I have an "IF" formula that I'm attempting to use to generate the same number over and over if there's any data in the rows of a single column. I've got the formula "working," however, it keep incrementing the number. I need it to input the actual number in the formula, though. My formula needs to input the number in the number of rows indicated in A1. I need to do this without dragging down the formula.

Thank you for your help!

Here's where I'm at:

Book3
	A	B	C	D
1	11
2
3			UNKNOWN	29.165745
4			UNKNOWN	30.165745
5			UNKNOWN	31.165745
6			UNKNOWN	32.165745
7			UNKNOWN	33.165745
8			UNKNOWN	34.165745
9			UNKNOWN	35.165745
10			UNKNOWN	36.165745
11			UNKNOWN	37.165745
12			UNKNOWN	38.165745
13			UNKNOWN	39.165745
14
Sheet2

Cell Formulas
Range	Formula
C3:C13	C3	=IF(SEQUENCE(A1),"UNKNOWN")
D3:D13	D3	=IF(C3<>"",(SEQUENCE(A1,1,"29.165745")),"")
Dynamic array formulas.

 

[Fluff]

How about

=SEQUENCE(A1,,"29.165745",0)