If Functions.ods (21.8 KB)
Please contact me to help me. It seems like it should be easy; but, I can’t figure it out.
Thanks,
Diane Upton
406-360-3368
dupton1377@gmai.com
The features
=IF(Condition;Result when True;Result when False)
and
=AND(Operand1;Operand2;…)
are FUNCTIONS in the LibreOffice , and in the OpenOffice, and in the Excel).
Just use proper brackets, and proper conditions, and proper operands…
=IF(AND(C27=J27;J27=F50);"To do if the result of the AND() is TRUE";"To do if the result of the AND() is False")
Note: the cells C27, J27, F50 are empty on the sheet “Storage Opening1” in your attached file.
Hi Tibor,
Thank you for your help. I apologize for the confusion; I previously copied the cells to show you and didn’t realize it changed the row numbers. I have attached the original file so you can see the actual layout.
I am trying to achieve the following: I want to select a size marked with an “X” in column C, find the corresponding cost in column J, and have that value appear in cell F50.
The file is named “Excell,” but it is a LibreOffice Calc file. I would be very grateful if you could show me how to set up this operation correctly.
Best regards,
Diane Upton
Hello again Tabor,
Ooops! the problem is on Page “Storage Opening1”
Diane
Hello Tibor! I entered the formula exactly as you suggested as follows:
IF(AND(C27=J27;J27=F50);“To do if the result of the AND() is TRUE”; “To do if the result of the AND() is False”)
But I still get the Err522 message in Cell F50.
What did I do wrong?
Thanks,
Diane
Yes! How did you do it? Please!
IT WORKS! ! ! ! Thank you so much!
Can I copy it and apply it to the other sizes so it will result with the correct answer in the F50 cell for that size vehicle?
Hi PKG,
I also have one more question: how does the correct value appear in cell F50 when that specific cell is not mentioned within the formula?
Best regards,
Diane Upton
Hi PKG,
I noticed that if I move the “X” to a different size in column C, the formula works perfectly. However, if I place the “X” in one of the cash cells below that range, it doesn’t seem to work.
Could you please help me understand why this is happening or how to adjust the formula to include those cells?
Best regards,
Diane Upton
@PKG
Why can you use XVERWEIS
but here it is
Also, if I try to edit it, to C31 - J31
and back to C33 - J33,
(when tried to include row 40, but this fails because of the grouped rows 34/35 I think)
both results in error #NAME
LO 24.2.7.2 (X86_64) / LibreOffice Community
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
The formula is @ cell F50 – see above.
1 Like
Thanks for the explanation.
How can I make the “cash” portion do the same in “F” 50?
It’s your table. How am I supposed to know in which area the formula should work if it’s not described exactly?
IF I understand correctly, you want to add the Month to Month option — rows 36 to 40 — to the search.
IF it is this, try
IFNA(VLOOKUP("x", C27:J31,8,0),0) + IFNA(VLOOKUP("x",C36:J40,8,0),0)
Rem: I’m using VLOOKUP because my LO install here does not have XLOOKUP.
You can use XLOOKUP of course.
or simply: =IFNA(VLOOKUP("x",C27:J40,8,0),0)
But don’t forget H50: =IFNA(VLOOKUP("x",C27:J40,7,0),0)
it was my first try yesterday, and assumed error was because of the grouped rows 34-35.
But of course it was because I don’t have XLOOKUP!
Ah! This is the “cash” portion.
Forgot this cell 
By the way: why at first without editions F50 shows up
com.microsoft.xlookup([…]
result
It seems like value being hard coded in the sheet
I can’t explain it, it’s probably some kind of substitute function.
