Ask Your Question
0

Slightly complex formula in calc fails

asked 2019-01-28 11:29:46 +0200

eypros gravatar image

updated 2019-01-28 11:32:17 +0200

I am trying to apply a slightly more complicated formula in Calc.

I have a spreadsheet with contents like:

MAP: 0.473  MAP: 0.49   MAP: 0.625

with each mAP in a separate cell.

Here is visual demonstration of my cells: image description

and I would like to get the maximum value of the numbers contained in these cells.

At first I used:

=RIGHT(A1, 4)

to get the number and then added:

=VALUE(RIGHT(A1, 4))

to get a numerical value. If I calculate those values in the row below and use a single formula as:

=MAX(A2:C2)

I get the correct result.

On the other hand if I substitute A2 in the last formula with its actual formula I got an error:

=MAX(VALUE(RIGHT(A1, 4)):C2)

So, is this something I cannot apply for some reason? Did I do something wrong? What am I missing here?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-28 11:40:55 +0200

JohnSUN gravatar image

Please try this variant

=SUMPRODUCT(MAX(VALUE(RIGHT(A1:C1; 5))))
edit flag offensive delete link more

Comments

Thanks a lot. That made the trick. Unfortunately I don't have enough points to upvote.

eypros gravatar imageeypros ( 2019-01-28 12:43:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-28 11:29:46 +0200

Seen: 19 times

Last updated: Jan 28