Ask Your Question
0

What does it means "IF(A24<"B",$B$13,H24+K24)" cell formulae?

asked 2016-01-16 08:45:19 +0200

kaishu gravatar image

In Libre Office what does it means "IF(A24<"B",$B$13,H24+K24)" . What does the A24<"B" means and what it returns also what is $B$13 used for?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2016-01-19 16:28:25 +0200

erAck gravatar image

A24<"B" is a comparison expression, it returns TRUE if the value of the cell content in A24 is smaller than the letter "B". The entire expression IF(A24<"B",$B$13,H24+K24) evaluates A24<"B" and if TRUE then IF executes the then branch which here it simply returns the value of cell $B$13 (an absolute reference to cell B13). If the comparison result is FALSE then IF executes the else branch and calculates H24+K24 and returns that result.

edit flag offensive delete link more
0

answered 2016-01-18 19:15:02 +0200

whytecrow gravatar image

Simply: if cell A24 contains single character B (or C, D, E,...), then show value of B13 cell, otherwise (if there is "A" or less or empty) sum the values in column H and K (on the same row). AFAIK it works with the first character of the string (A24 in your case), others are ignored.

Dollar sign means fixed position, so you may copy (fill down usually) the formula to another row ($13) or column ($B). The reference will always be the same - B13.

edit flag offensive delete link more

Comments

Thats good to know about the fixed reference, I have been struggling with that, So any of the references can be fixed, can I mix them so that some are fixed and others dynamic?

Chris UK gravatar imageChris UK ( 2016-01-20 05:19:20 +0200 )edit

Yes, you can mix them as you like. We don't speak of "fixed" or "dynamic" though, it is absolute or relative. The difference is when you copy&paste formula cells, absolute references stay the same while relative references are then relative to the position where you paste the formula cell to. See https://help.libreoffice.org/Calc/Add...

erAck gravatar imageerAck ( 2016-01-22 14:50:36 +0200 )edit

if cell A24 contains single character B (or C, D, E,...), then show value of B13 cell

That's not quite correct, the comparison is <"B" meaning smaller than, so if A24 contained B the expression would not show value of B13. Also, it is not limited to single characters, "AB" is still smaller than "B", as is any number (all numbers are smaller than any string).

erAck gravatar imageerAck ( 2016-01-22 14:57:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-01-16 08:45:19 +0200

Seen: 115 times

Last updated: Jan 19 '16