Is there a wildcard I can use for numbers in Excel?

[slames]

I need to determine if a number is divisible wholey by 4 and if it isn't I need to round it up to the next whole number that is.
So if a number is xx.25, I must add 3, if xx.50 add 2 and if xx.75 add 1. Is there a way of testing if my values equal the above like a wildcard in access?. I need only to check the last two digits, the rest of the number is irrelevant.
Thanks
Steph

 

[Nikita6003]

slames,

why not just use the MOD function? this results in the remainder after division rather than the result of the division
25 Mod 4 = 1
26 Mod 4 = 2
27 Mod 4 = 3
28 Mod 4 = 0

Hope this helps

Cheers Nikki
;-)