formula based on multiple condition

[abdelfattah]

hello
i need formula about this
If a1 is equal to 5, the cell B1 is written in it basic, and the four cells underneath write a sub in them, and if a1 is written in it 4, b1 remains written in it essential, and the three cells below it are written in them sub. And so on briefly what result in column b based on number on a1 always in b1= basic is fixing not variable the variable about "sub" changes based on number if number 4 the "sub" equal 3 times number is 5 the sub 4 times

for more explenation i write in a1 and result in column b based on number

 

[abdelfattah]

if is possible by code is ok and adjusting a simple when i write in any cell in column a not only a1

 

[Fluff]

In B1
=IF(A1<>"","Basic","")
In B2 copied down as far as needed
=IF(ROW()<=A$1,"SUB","")

 

[abdelfattah]

hi, Fluff
i would that if i write in any cell in column a gives me result like this

 

[Eric W]

Does this work for you?

Book1
	A	B
1	4	basic
2		sub
3		sub
4		sub
5
6
7	6	basic
8		sub
9		sub
10		sub
11		sub
12		sub
13
14	4	basic
15		sub
16		sub
17		sub
18
19
20	2	basic
21		sub
22
23	3	basic
24		sub
25		sub
26
27
Sheet10

Cell Formulas
Range	Formula
B1:B27	B1	=IF(A1<>"","basic",IFERROR(IF(OFFSET(B1,-1,0)<>"",IF(ROW()-LOOKUP(2,1/(A$1:A1<>""),ROW(A$1:A1))>LOOKUP(2,1/(A$1:A1),A$1:A1)-1,"","sub"),""),""))

 

[Fluff]

i would that if i write in any cell in column a gives me result like this

Moving the goalposts again I see.

 

[abdelfattah]

well done, Eric that's what i would thank you so much

 

[abdelfattah]

sorry Fluff if i don't specify from the beginning i was to be like formula of Eric or code

 

[Eric W]

Glad we could help!