View Single Post
  #5  
Old 01-09-2009, 06:42 PM
mewingkitty's Avatar
mewingkitty mewingkitty is offline
Valued Forum Contributor
 
Join Date: 29 Sep 2008
Location: Grande Prairie, Alberta, Canada
MS Office Version:Excel 2007
Posts: 902
mewingkitty has an addiction to Excel
Send a message via MSN to mewingkitty Send a message via Yahoo to mewingkitty
Not exactly what I was hoping for.

I had a much longer code with several IF's which, if any of them came back as true, I would want to terminate all following if statements, and proceed with the next NEXT part of the loop.

My reasoning behind using this simplistic example was to save time for anyone looking at it, and make it easier for anyone else with the same question to understand if they found it later.

So...
How do you loop back to a NEXT if a condition is met half way through the code?
__________________
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Reply With Quote