| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need help with Nested IF - How does Excel read
Thanks to you both for the sanity check!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel Nested Functions | Excel Worksheet Functions | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| Nested Sub-Totals in Excel | Excel Discussion (Misc queries) | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Linear Mode
