HOW TO CHANGE FROM VALUE TO JUST BLANKS CELLS

[Antoan]

Hello everyone!



Could you help me with case? I would like to change the VALUE field into just blanks cells in the J COLUMN.

Do you maybe know how to do that?

Thank you in advance!


Your contribution would be highly appreciated!

Decok Maintanance.xlsx
	E	F	G	H	I	J
1	Reference Date	Work	Normal Duration	People Required	Per Day	Actual Per day 12 hours shift
2	27.10.2008	4,0	4,0	1	1	0,1
3	10.11.2008	6,0	3,0	2,0	2	0,2
4	1.12.2008	16,0	8,0	2,0		#VALUE!
5	1.12.2008	32,0	16,0	2,0		#VALUE!
6	1.12.2008	48,0	24,0	2,0		#VALUE!
7	1.12.2008	16,0	16,0	1,0	7	0,6
8	8.12.2008	2,0	2,0	1,0		#VALUE!
9	8.12.2008	8,0	4,0	2,0		#VALUE!
10	8.12.2008	10,0	5,0	2,0		#VALUE!
11	8.12.2008	6,0	3,0	2,0		#VALUE!
12	8.12.2008	3,0	1,5	2,0		#VALUE!
13	8.12.2008	8,0	8,0	1,0		#VALUE!
14	8.12.2008	6,0	3,0	2,0		#VALUE!
15	8.12.2008	2,0	2,0	1,0		#VALUE!
16	8.12.2008	2,0	2,0	1,0		#VALUE!
17	8.12.2008	4,0	4,0	1,0		#VALUE!
18	8.12.2008	8,0	8,0	1,0		#VALUE!
19	8.12.2008	8,0	8,0	1,0		#VALUE!
20	8.12.2008	6,0	6,0	1,0	18	1,5
21	15.12.2008	4,0	2,0	2,0		#VALUE!
22	15.12.2008	6,0	3,0	2,0		#VALUE!
23	15.12.2008	7,0	7,0	1,0		#VALUE!
24	15.12.2008	6,0	3,0	2,0		#VALUE!
25	15.12.2008	1,0	1,0	1,0		#VALUE!
26	15.12.2008	1,0	1,0	1,0		#VALUE!
27	15.12.2008	8,0	4,0	2,0		#VALUE!
28	15.12.2008	10,0	10,0	1,0		#VALUE!
29	15.12.2008	4,0	2,0	2,0		#VALUE!
30	15.12.2008	6,0	3,0	2,0		#VALUE!
31	15.12.2008	4,0	2,0	2,0	18	1,5
32	18.12.2008	2,0	1,0	2,0		#VALUE!
33	18.12.2008	3,0	3,0	1,0		#VALUE!
34	18.12.2008	2,0	1,0	2,0		#VALUE!
35	18.12.2008	3,0	3,0	1,0		#VALUE!
36	18.12.2008	2,0	2,0	1,0		#VALUE!
37	18.12.2008	4,0	2,0	2,0		#VALUE!
38	18.12.2008	2,0	1,0	2,0		#VALUE!
39	18.12.2008	4,0	2,0	2,0		#VALUE!
40	18.12.2008	2,0	2,0	1,0		#VALUE!
41	18.12.2008	4,0	4,0	1,0		#VALUE!
42	18.12.2008	2,0	1,0	2,0		#VALUE!
43	18.12.2008	3,0	3,0	1,0		#VALUE!
44	18.12.2008	2,0	1,0	2,0		#VALUE!
45	18.12.2008	4,0	2,0	2,0		#VALUE!
46	18.12.2008	2,0	1,0	2,0		#VALUE!
47	18.12.2008	3,0	3,0	1,0		#VALUE!
48	18.12.2008	12,0	12,0	1,0	26	2,2
Sheet1

Cell Formulas
Range	Formula
I2:I48	I2	=IF(E2=E3,"",SUMIFS(H$2:H2,E$2:E2,E2))
J2:J48	J2	=[@[Per Day]]/12

 

[Fluff]

How about

=IF([@[Per Day]]="","",[@[Per Day]]/12)