is there a better way to do If i2 = 25 Or i2 = 50 Or i2 = 75 Or i2 = 100

[0o0o0]

Yep its 4 am im dead tired.. and im creating this in an if statement.

If i2 = 25 Or i2 = 50 Or i2 = 75 Or i2 = 100 Or i2 = 125 Or i2 = 150 Or i2 = 175 Or i2 = 200 Or i2 = inifinity

I know im not thinking... is there like If i2 = multiples of 25 then.. im over thi.... zzzz zzzz zzzzz zzzzz zzzzz zzzzz night! lol lemme know thanks.

[davesexcel]

What is supposed to happen in the formula?

[José Augusto]

Good dreams, ...
=IF(AND(MOD(I2,25)=0,I2<>0),"do this","do that")

[Pepe Le Mokko]

Yep its 4 am im dead tired.. and im creating this in an if statement.

If i2 = 25 Or i2 = 50 Or i2 = 75 Or i2 = 100 Or i2 = 125 Or i2 = 150 Or i2 = 175 Or i2 = 200 Or i2 = inifinity

I2 = infinity ? Which Infinity ? Aleph-nought Aleph -One.... ?

[0o0o0]

omg sorry guys!! I posted in excel formulas, and meant it for VBA.. doh!

Do I have the capability of deleting this entire thread sorry!!


Basically For i2 = 1 To 300

when i2 reaches 25 50 75 100 125 150 175 200 225 250 275 300

it does an if statement of... a quick clear cache task..

I just wanted to know if theres a more condensed way for this.. than putting If i2 = 25 Or i2 = 50 Or i2 = 75 Or i2 = 100 Or i2 = 125 Or i2 = 150 Or i2 = 175 Or i2 = 200

Your magical wizardry converted to my language lol....... If i2=(every multiple of 25) ..go do something...

but I put this in excel formulas not vba.. so sorry.

[AliGW]

This thread has been moved to the VBA section.

[0o0o0]

thanks. Sorry

[protonLeah]

If myvar Mod 25 = 0 Then
End If

[Rick Rothstein]

Try it like this...

Please Login or Register  to view this content.

[0o0o0]

Nice, will try, thanks I was just reading up on "case"... think ya saved me a day of offtrack reading lol

WORKS AWESOME THANKS.. even simpler code than I expected. Thank you.

[Rick Rothstein]

By the way, here is an alternate method you could use...

Please Login or Register  to view this content.