Help with Long IF,AND,OR formula

jbennett7766

Hi,

Needing some help with the below formula. Everything is working correctly but the last IF/AND/OR statement and can't figure out what I'm missing. Any help is greatly apricated.

=IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = true, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = true))), "Reconnect Needed", IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = false, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = false))), "Reconnected", IF(AND([Water Disconnected]@row = true, OR([Water Meter #]@row = "NO Meter"), OR([Electric Disconnected]@row = true), "Disconnected", ""))))

rrenee

It appears you're missing one ending parenthesis for the last AND() statement right before "Disconnected", and also have one extra closing parenthesis for the three IF() statements that needs to be removed. Try this:

=IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = true, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = true))), "Reconnect Needed", IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = false, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = false))), "Reconnected", IF(AND([Water Disconnected]@row = true, OR([Water Meter #]@row = "NO Meter"), OR([Electric Disconnected]@row = true)), "Disconnected", "")))