Ignore blank cells

[soul1974]

Morning,
I keep getting recess front in my blank celss . How do i get the formula to ignore blank cells?
=IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct"))

 

[gordsky]

Morning,
I keep getting recess front in my blank celss . How do i get the formula to ignore blank cells?
=IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct"))

you could either qrap the code around another IF statement saying if cell <> "" or include an and statement in your above code. You dont say where the "blank cells" are so little difficult to be more specific.

 

[soul1974]

you could either qrap the code around another IF statement saying if cell <> "" or include an and statement in your above code. You dont say where the "blank cells" are so little difficult to be more specific.

HI
Please see image, I don't want to display information in the empty cell

 

[soul1974]

you could either qrap the code around another IF statement saying if cell <> "" or include an and statement in your above code. You dont say where the "blank cells" are so little difficult to be more specific.

HI
Please see img, I don't want to display information in the empty cell
View attachment 58232

 

[gordsky]

wrap your code inside another if statement

If(e2="","",addyourcodehere)

 

[soul1974]

wrap your code inside another if statement

If(e2="","",addyourcodehere)

HI,

Thanks for the code , bot that does not work

 

[gordsky]

The code works. I take it the yellow column is column "F"?
I not in your code you have " ; " (semicolon) where i would normally have " , " (comma) so if thats because of regional programming change the comma in my code to a semicolon

if youre still having issues attach a sample worksheet not an image

 

[soul1974]

The code works. I take it the yellow column is column "F"?
I not in your code you have " ; " (semicolon) where i would normally have " , " (comma) so if thats because of regional programming change the comma in my code to a semicolon

The code works. I take it the yellow column is column "F"?
I not in your code you have " ; " (semicolon) where i would normally have " , " (comma) so if thats because of regional programming change the comma in my code to a semicolon

if youre still having issues attach a sample worksheet not an image

level 9 measurement (18-02-22).xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Room No#	Unit Type	Glass Side	Act Trap From Front Centre Wall	Min Req Trap From Front Centre Wall	ADJUSTMENT	Trap Centre From Wall	ACT width	ADJ WIDTH LESS 10mm	ACT length	ADJ LENGTH LESS 10mm	Rear Adjustment	Glass Cut out size	Internal Slab	Notes	Architect Size	Width	W Difference	Length	L Differnce
2	940L	E2.1	right	100	125	-25	360	910	900	1670	1660	Recess Front	955	1400	260mm cutout on back right	900x1715	900	10	1715	-45
3	940R	E2.1	left	130	125	5	405	900	890	1550	1540	1540	835	1280		920x1610	920	-20	1610	-60
4					125							Recess Front
5					125							Recess Front
6					125							Recess Front
Sheet6

Cell Formulas
Range	Formula
N2:N3	N2	=IF(K2<>"",K2-715,"")
O2:O3	O2	=IF(Table25[@[ACT length]]<>"",Table25[@[ACT length]]-(190+40+40),"")
G2:G3	G2	=IF(Table25[@[Act Trap From Front Centre Wall]]<>"",Table25[@[Act Trap From Front Centre Wall]]-Table25[@[Min Req Trap From Front Centre Wall]],"")
J2:J3	J2	=IF(Table25[@[ACT width]]<>"",Table25[@[ACT width]]-10,"")
L2:L3	L2	=IF(Table25[@[ACT length]]<>"",Table25[@[ACT length]]-10,"")
S2:S3	S2	=IF(Table25[@[ACT width]]<>"",Table25[@[ACT width]]-Table36[@Width],"")
U2:U3	U2	=IF(Table25[@[ACT length]]<>"",Table25[@[ACT length]]-Table36[@Length],"")
M2:M6	M2	=IF($E2>$F2,$L2-$G2+5,IF($E2<F2,"Recess Front","Correct"))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
U2:U6,S2:S6	Cell Value	>0	text	NO
G2:G6	Cell Value	>1	text	NO
G2:G6	Cell Value	<0	text	NO
R2:U6	Cell Value	<0	text	NO

 

[gordsky]

I have tested the code I gave you with the sample worksheet you posted and it works fine. I note in the sample workbook you dont have my code in column M (which is the cell you said you wanted blank if blank.) Did you substitute the "addyourcodehere" in my code with your own code??

the code I supplied was

If(e2="","",addyourcodehere)

with your formula in it

=IF(E2="","",IF($F2>$G2,$M2-$H2+5,IF($F2<G2,"Recess Front","Correct")))

 

[soul1974]

Sorry it does not work.