Ask Your Question
0

How can I add a function in LibreOffice Calc so that values of cells would not exceed calculated value of 20? [closed]

asked 2014-01-21 11:31:19 +0200

v_mark gravatar image

I have spreadsheets calculating assumed development of some attributes. The value of an attribute should't exceed 20 but in some cases the development is so good it goes over the limit. How can I add there a function or something that limits all the values too high to appear as 20?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 17:42:02.113124

3 Answers

Sort by » oldest newest most voted
0

answered 2014-01-21 12:12:41 +0200

Pedro gravatar image

Just use an IF function.

E.g. =IF(A1>20;20;A1)

This means "If value in A1 is greater than 20 show the value 20 otherwise use the value in A1"

Hope this is what you asked :)

edit flag offensive delete link more
0

answered 2014-01-21 17:42:29 +0200

v_mark gravatar image

@Pedro

I'm pretty sure that is exactly what I'm looking for. But it seems I need to ask another question and that is:

If I already have a function like this for the cell

=((Chart1.A2/Chart1.A1)*B1)

how can I add the IF function there without getting error messages?

Thank you for your quick response!

edit flag offensive delete link more

Comments

@v_mark

Just repeat the function as in =IF((Chart1.A2/Chart1.A1)xB1>20;20;(Chart1.A2/Chart1.A1)xB1) or even more elegant =MIN(20;(Chart1.A2/Chart1.A1)xB1) as suggested by @karolus

Note: I had to replace asterisk with x because in comments it is used to convert text to Bold...

Pedro gravatar imagePedro ( 2014-01-21 18:03:39 +0200 )edit

Gotcha! Thanks a million for your help!

v_mark gravatar imagev_mark ( 2014-01-21 19:37:29 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-01-21 11:31:19 +0200

Seen: 180 times

Last updated: Jan 21 '14