if statmens with multiple criteria

[kelvin_9]

hello all,

can i use more than 1 IF statment in cell C23 with these criteria?
1) if N22 is 0, return G22 value
2) if G22 is less than 10, return G22+N22
3) if G22 is greater than 10, return G22-negative value

much appreciate!

thanks everyone

hotel balance - v1.1.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O	P
22	10	1	9	1	10		kelvin	12345678	1	abc123		0	/
23			0		0							0	/
24			0		0							0	/
25			0		0							0	/
26			0		0							0	/
v1.6

Cell Formulas
Range	Formula
N22:N26	N22	=IF(SIGN(C22)=SIGN(G22),C22-G22,C22+G22)
O22:O26	O22	=IF(N22=0,"/",IF(N22>=1,"A to B",IF(N22<0,"B to A")))
E22:E26	E22	=C22-D22
G22:G26	G22	=C22-D22+F22

 

[Ezguy4u]

Kelvin what if G22 equals 10? What do you want for a result.

 

[kelvin_9]

Kelvin what if G22 equals 10? What do you want for a result.

thank you very much for your reply, Ezguy4u

how about this, will it be more clear?
G22 is a value from: opening-rental+return

hotel balance - v1.1.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O
21	opening quantity	rental quantity	net balance	return quantity	closing quantity		guest name	guest contact	number of stay	booking number		variance	action
22	10	1	9	1	10		kelvin	12345678	1	abc123		0	/
23			0		0							0	/
24			0		0							0	/
25			0		0							0	/
26			0		0							0	/
v1.6

Cell Formulas
Range	Formula
N22:N26	N22	=IF(SIGN(C22)=SIGN(G22),C22-G22,C22+G22)
O22:O26	O22	=IF(N22=0,"/",IF(N22>=1,"park to hotel",IF(N22<0,"return to park")))
E22:E26	E22	=C22-D22
G22:G26	G22	=C22-D22+F22

 

[kelvin_9]

someone can help in column C?
it wont work correctly if column N is negative numbers.

my rules:
sum column G & column N (G+N)
if column G is less than 10, it returns 10, C16 is an example
if column G is greater than 10, it can not returns 10, C17 is an example

hotel balance - v1.1.xlsx
	C	D	E	F	G	H					M	N	O
13	opening quantity	rental quantity	net balance	return quantity	closing quantity							variance	action
15	10	3	7	1	8							2	park to hotel
16	10	5	5	7	12							-2	return to park
17			#VALUE!		#VALUE!							#VALUE!	#VALUE!
18	#VALUE!		#VALUE!		#VALUE!							#VALUE!	#VALUE!
v1.6

Cell Formulas
Range	Formula
N15:N18	N15	=IF(SIGN(C15)=SIGN(G15),C15-G15,C15+G15)
O15:O18	O15	=IF(N15=0,"/",IF(N15>=1,"park to hotel",IF(N15<0,"return to park")))
C15:C18	C15	=IF(G14<=10,SUM(G14,N14),IF(G14>=10,"",SUM(G14,N14)))
E15:E18	E15	=C15-D15
G15:G18	G15	=C15-D15+F15

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O14:O18	Cell Value	contains "park to hotel"	text	NO
O14:O18	Cell Value	contains "return to park"	text	NO