Need help with Nested IF - How does Excel read

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top