Formula resulting in FALSE

[Abbadon486]

I have the formula sa below, and cant work why its coming out as false when its parent worksheet was a similar formula with only one additional change made to it fro this one.

=IF(AE12="D","",IF($V12="",IF($U12=AF$6,"P",IF($V12=AF$6,"E",IF(Breakdown_Table!E7=AF$6,"B",IF($Y12=AF$6,"D",IF(AE12="P","P",IF(AE12="E","E",IF(AE12="B","E","")))))))))

Any advice greatly appreciated

Tim

[Jonmo1]

It's returning FALSE because 1 or more of the IF conditions is FALSE.

I'd suggest using the "Evaluate Formula" tool on the Formulas Tab to step through the formula and see where it's getting the FALSE from.

I would have to guess it's the 2nd IF
IF($V12=""

Because that's the only one that you haven't specified a 'do this if false' part.