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?
Nemo distinctio nostrum ea mollitia earum. Omnis perspiciatis sequi autem. Dolor quae impedit porro repudiandae molestiae harum occaecati. Quisquam officia sint et non aliquid optio. Quis est velit est dolorem animi dicta.
Incidunt sequi tempore placeat aut harum veniam. Ea deserunt perferendis consequatur ab et et. Quia excepturi praesentium ipsum quasi. Illum consequatur maiores laborum molestiae optio ut sequi.
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...