Help with Index and MAX

[apollo753]

I have a formula that will take the last entry in a row. I need the last decimal number to be to three places.
I use this formula.....I think I need to add roundup to three places but can't figure it out.

Please Login or Register  to view this content.

Capture.JPG
Capture1.JPG

Thanks

[daffodil11]

Just encapsulate the final concatenation in Text(blahblah,"0.000")

See attached picture.

[apollo753]

Capture1.jpg is how I want all the results to look like in cell E6. 15 (15-1) (.938) if row 3 was gone the result in E6 should be
12 (12-1) (.920) but it displays the (.920) as (.92)

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[apollo753]

Attached...Thanks

[FDibbins]

Here is a slightly different approach...
=OFFSET(A1,COUNTA(A:A)-1,0)&",("&OFFSET(A1,COUNTA(A:A)-1,1)&",) ("&OFFSET(A1,COUNTA(A:A)-1,2)&",) ("&TEXT(OFFSET(A1,COUNTA(A:A)-1,3),"0.00")&")"

10,(5,) (5,) (0.50)

[apollo753]

Thanks but not what I what. I need the result to be

5 (5-5) (0.500)

[FDibbins]

OK so change the "space" part and add an extra 0 in the TEXT argument

[apollo753]

adding a zero as text will not work either. if the next entry is
11 (8-3) (.7270)

I need it to be 3 place only always. (.000)
I though the function roundup would work.

[FDibbins]

adding a zero as text will not work either.

did you try it?

	E	F
8	0.7	0.700
9	0.77	0.770
10	0.777	0.777
11	0.7777	0.778

E8=TEXT(E8,"0.000") copied down