Mod function to find specifically 5 only

Hi All

I'm using the mod function to check if the row is a mulitple of 5

Please Login or Register  to view this content.

The mod function fires everytime it hits the Mod: 5, 10, 15, 20, 25...

The trick is that I only want to find specifically 5, 15, 25, 35, 45,...

How is this done please?


Cheers

You mean

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Thanks for your response Alvin.

Target.Row Mod 10 = 5 didn't work in that way. But I did follow this thinking and used this:

Please Login or Register  to view this content.

Cheers

You're welcome, glad it you got it working now



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin