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?
Aliquid at beatae quisquam nobis et hic saepe. Molestias aliquam iusto architecto mollitia corporis tempora tenetur. Ipsa numquam enim voluptas eos. Sit voluptatibus exercitationem est adipisci.
Aut minus perferendis accusamus provident. Accusamus magni quaerat maiores aspernatur aliquid. Tempore perferendis molestiae eaque expedita cupiditate accusantium. Perferendis doloribus odit corporis voluptas suscipit. Doloremque architecto et temporibus velit aspernatur nesciunt nostrum. Voluptatibus iste atque dolorem minima qui molestiae.
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...