Need help with Nested IF - How does Excel read

[ChipLove]

Hi,

I'm working on a spreadsheet and have come across a seemingly simple
nested IF but am confused if it is correct - previous owner of process
is not available.

Here is the original formula

=IF(V22>=J22,IF(J22<V22,J22,J22),V22)

I read this as when V22 >= J, then return J22 (true), else return V22
(false). The formula looks complicated to me because the second IF
appears to return J22 in all cases when V22>=J22, otherwise the false
part is retuurn V22 when V22 is < J22.

I think I can get the same result with the following:

=IF(V22>=J22,J22, V22)

Am I missing something/anything is how the nested IF works in the
original formula? Thanks for the look.

Chip

 

[Ardus Petus]

IMHO, you're perfectly right. The 2nd IF is useless.

 

[Tom Ogilvy]

=IF(V22>=J22,J22, V22)

would be equivalent and the nested IF is extraneous.

 

[Chipster]

Thanks to you both for the sanity check!