formula long sample in exels

[iraidotel]

Dear All, experts exels

My name is Ira, new to exels
and want to make a formula in exels, his case the sample length of 10 meters, for the first sample (sample1) and long past its always 0:35 meters, and (sample2) 3 meters in length, (sample3) 3 meters, and (sample4) his rest if less of 1 meter entry in sample4, and if more than one meter into the next sample number.

maybe anyone can help me

thank you,

Regards, Ira

 

[Somendra Misra]

Hi Ira,

Welcome to chandoo.org forum.
I doubt that explanation make any sense, may be you have to explain it more in depth.

Regards,

 

[Deepak]

As Somendra Misra said it just hit nothing, however check attached if helped.

 

[NARAYANK991]

Hi Ira ,

See this file for another option.

If you change the value in E2 , the values will change.

Narayan

 

[iraidotel]

Hi Ira ,

See this file for another option.

If you change the value in E2 , the values will change.

Narayan

Dear Mr. NARAYANK991, and Mr. Deepak, somendra Misra
thank her response, and could open my horizons about exels

I was looking for this formula, on the instructions of the vendor dati provision in a contract coal sampling in the name assigned to the provisions under

how do I mean first sample is always long 0:35 and 0:35 last sample.
for the second sample 3 meters, 3 meters if enough third and his seterus and if the remainder is less than 1 meter inserted into the sample number before and I do not know how, maybe you can help me

so that the list does not appear when we enter three numbers on the filter.

thus

regards, Ira