Ask Your Question

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:


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


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:


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

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

JohnSUN gravatar image

Please try this variant

edit flag offensive delete link more


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


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

Seen: 19 times

Last updated: Jan 28