Check value on block

[brainzlp]

Hello all,

is there a way to look if inserted value is on specific block?

I mean, i have several number "blocks" (1-99 ; 100-199; 200-299 ....)

If value is on block1, display msgbox "value found on first block - [1-99] " etc etc

Hope you can understand me

See file in attachmente

P.S. I need this on VBA

[JieJenn]

I am getting an error that my response contains SQL Injection. Anyway, maybe give UDF a try (code is in the attachment).

[MickG]

Try this UDF:-
Enter in "D2" as :- =fdnum(A2,C2)

Please Login or Register  to view this content.

[brainzlp]

that's exactly what i was asking, although i though i could do it from there.

See in attach what i really need to do in my project, and hopefully you can help me out

[brainzlp]

I am getting an error that my response contains SQL Injection. Anyway, maybe give UDF a try (code is in the attachment).

Have you seen the new attachment, is there a way to adapt your function to my cost calculation?

[brainzlp]

Hello

I've tested your UDF and doesn't work, neither JieJenn's neither MickG's UDF

I need the block to be as in attachment, check and let me know how can i define the BLOCK with [0-0,07[ FOR EXAMple, and test the value 0,07 and 0,071

Get back to me asap