I don't know which "if" function to use in my Calc spreadsheet and can't complete my contract until I do.

[dupton]

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

[Zizi64]

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).
UJust use proper brackets, and proper conditios, 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.