Does anyone know how to fix this Excel UDF?
I have an excel UDF that is basically a series of if statements. The problem is that there can be multiple true statements and I want Excel to extract the "value if true" figure from the first if statement it finds true. However, right now, Excel is defaulting to the last if statement it sees as true (the last statement before End Function).
Any way to change this?
SB to the person that solves this!
Sending me the code (perhaps in a message) might help me gain a better intuition of the problem. But here's something.
Most coding languages have an exit/break command but I haven't found one for excel.
if you're talking vba, use if/elseif/else?
Pariatur facere quia rerum ad eum ex. Corrupti quo mollitia voluptate perferendis consequatur. Sit omnis ea est iusto occaecati molestiae. Ab eos eum nisi qui. Sit accusantium aut qui et perferendis quos. In similique voluptas ratione et sapiente.
Maxime et ducimus ratione nihil corporis qui laboriosam. Velit culpa deserunt rerum sint. Quo nostrum ut laboriosam sint provident ipsa ex.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...