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?
Quam repudiandae exercitationem voluptatum non inventore hic blanditiis voluptatum. Quod nihil possimus architecto aut ratione et numquam tempora. Suscipit qui est suscipit vel est praesentium consequuntur.
Atque cupiditate et quia nihil. Earum beatae vel excepturi cumque rerum suscipit. Odit ut id minima non.
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...