Fill Series Number (Positive & Negative) Based on A Number

[muhammad susanto]

dear all...

i have layout table like this below, how to make series number (positive & negative number) simultance based on input a number
this table:

hitung R2 kejari.xlsb
	V	W	X	Y	Z
9				Expected result
10	Input	data (given)		Series Postitive	Series Negative
11	1%	Apple	Very good	0%	0%
12			Good	1%	-1%
13			Enough	2%	-2%
14			Bad	3%	-3%
15	3%	Banana	Very good	0%	0%
16			Good	3%	-3%
17			Enough	6%	-6%
18	10%	Mangoes	Very good	0%	0%
19			Good	10%	-10%
20			Enough	20%	-20%
21			Bad	30%	-30%
22	etc..
1 vixion

my targe (expected result) in cell Y11 & Z11 down
Note : Without Macro/vba
any help, greatly appreciated..

.sst

 

[Fluff]

How about

+Fluff New.xlsm
	V	W	X	Y	Z
10	Input	data (given)		Series Postitive	Series Negative
11	1%	Apple	Very good	0%	0%
12			Good	1%	-1%
13			Enough	2%	-2%
14			Bad	3%	-3%
15	3%	Banana	Very good	0%	0%
16			Good	3%	-3%
17			Enough	6%	-6%
18	10%	Mangoes	Very good	0%	0%
19			Good	10%	-10%
20			Enough	20%	-20%
21			Bad	30%	-30%
Data

Cell Formulas
Range	Formula
Y11:Y21	Y11	=IF(V11<>"",0,Y10+LOOKUP(2,1/(V$11:V11<>""),V$11:V11))
Z11:Z21	Z11	=Y11*-1

 

[muhammad susanto]

How about

+Fluff New.xlsm
	V	W	X	Y	Z
10	Input	data (given)		Series Postitive	Series Negative
11	1%	Apple	Very good	0%	0%
12			Good	1%	-1%
13			Enough	2%	-2%
14			Bad	3%	-3%
15	3%	Banana	Very good	0%	0%
16			Good	3%	-3%
17			Enough	6%	-6%
18	10%	Mangoes	Very good	0%	0%
19			Good	10%	-10%
20			Enough	20%	-20%
21			Bad	30%	-30%
Data

Cell Formulas
Range	Formula
Y11:Y21	Y11	=IF(V11<>"",0,Y10+LOOKUP(2,1/(V$11:V11<>""),V$11:V11))
Z11:Z21	Z11	=Y11*-1

hi Fluff, thank you so much..
Working 100%.

 

[Fluff]

You're welcome & thanks for the feedback.