Need help with Nested IF - How does Excel read
 

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

Need help with Nested IF - How does Excel read
 

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

--
AP

a écrit dans le message de
ups.com...
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

Need help with Nested IF - How does Excel read
 

=IF(V22=J22,J22, V22)

would be equivalent and the nested IF is extraneous.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
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

Need help with Nested IF - How does Excel read
 

Thanks to you both for the sanity check!