How to use multiple nested IF statements in OpenOffice cell

Question

In an OpenOffice/Libre Office spreadsheet, I would like to display a value in a cell if two other cells have certain values. After many searches, I didn't find out how to do this. Can someone help solve this please?

In cell G2, I'd like to write a statement saying:

If A2 equals "PayPal Express Checkout Payment Received" and if C2 = "GBP", then display the value of F2, else display nothing.

Answer 1

Try this:

=IF(AND(A2="PayPal Express Checkout Payment Received";C2="GBP");F2;"")