Nested If function returning FALSE instead of number

Hello,
The following if function is not working in a Salary and benefit spreadsheet I am working on to determine if someone is eligible for management leave pay. We also have two types of management leave pay based on when you were hired. The formula I wrote is trying to determine first if you are not management then return 0. the second portion of the formula states if you are management and hired after a specific date then calculate management leave pay and the last portion of the formula is to calculate management leave pay if you were hired before the specific date. When I use this formula I am getting a return value of FALSE instead of the management leave pay amount I need to have calculated. Can someone please tell me where the formula is wrong? I am kind of rusty, just got back to work from a long maternity leave where I didn't look at a computer more than 5 times. Thanks in advance for the help!

=IF(DATABASE!AG22="",0,IF(DATABASE!AG22="Y"&DATABASE!AQ22="Y",((AI22/26/80)*100),IF(DATABASE!AG22="Y"&DATABASE!AQ22="N",((AI22*0.04)-1500)+((AI22/26/80)*72))))

The database sheet it is referring to is where the calculation determining if you are management, and what your hire date was.

You don't use the ampersand symbol & to denote logical AND - use the AND function instead (& is used to join two strings together). Your formula should be along these lines:

=IF(DATABASE!AG22="",0,IF(AND(DATABASE!AG22="Y",DATABASE!AQ22="Y"),AI22/26/80*100,IF(AND(DATABASE!AG22="Y",DATABASE!AQ22="N"),AI22*0.04-1500+AI22/26/80*72,"condition_1"),"condition_2"))

There are two other conditions you have not accounted for, i.e. N Y and N N, so that is why you are getting FALSE.

Hope this helps.

Pete

This is not a valid AND expression
DATABASE!AG22="Y"&DATABASE!AQ22="Y"

Should be
AND(DATABASE!AG22="Y",DATABASE!AQ22="Y")

Thanks for the help Pete! There won't be a condition N N or N Y, the cells are all blank except for manual input of Y into cells in the column DATABASE!AG for management employees. from there the second column would have Y or N so the only conditions we would see are a blank cell in AG, Y in AG and N in AQ or Y in AG and Y in AQ.

Okay, in my formula just put zero instead of "condition_1" and "condition_2".

Hope this helps.

Pete