Hi jws21,

To test for multiple conditions in an IF statement, you can use the AND or OR function. The correct format for testing if both of two conditions are correct using the AND function is:

1. =IF(AND(D1415,G14="Y"), value_if_true, value_if_false)

In this formula, the AND function is used to test if both conditions are true. If both conditions are true, the formula will return the value_if_true result. If either condition is false, the formula will return the value_if_false result.

Make sure to replace "value_if_true" and "value_if_false" with the appropriate values or formulas for your specific situation.

Best regards,