Value of a cell to be maximum of desired digits

[hsandeep]

C3:C7 generates numerical values. It can be +ve value or –ve value or 0
B2=+ve integer

F3:F7=IF value of a cell of C contains digits>$B$2 then 0 else C

How to accomplish?
Thanks in advance

Book2.xlsx
	B	C	D	E	F
2	4
3		142			142
4		144.669			142.669
5		14568			0
6		1			1
7		0			0
8		-14789.56			0
9		4444			4444
10		44445			0
Sheet6

 

[Peter_SSs]

Is this what you mean?

23 01 14.xlsm
	B	C	D	E	F
2	4
3		142			142
4		144.669			144.669
5		14568			0
6		1			1
7		0			0
8		-14789.56			0
9		4444			4444
10		44445			0
Sheet2 (2)

Cell Formulas
Range	Formula
F3:F10	F3	=IF(LEN(INT(ABS(C3)))>B$2,0,C3)

 

[hsandeep]

Is this what you mean?

23 01 14.xlsm
	B	C	D	E	F
2	4
3		142			142
4		144.669			144.669
5		14568			0
6		1			1
7		0			0
8		-14789.56			0
9		4444			4444
10		44445			0
Sheet2 (2)

Cell Formulas
Range	Formula
F3:F10	F3	=IF(LEN(INT(ABS(C3)))>B$2,0,C3)

Absolutely...this meets my requirements. Thanks Sir.

 

[Peter_SSs]

You're welcome. Glad to help.