maybe try it this way then : =IF(MOD(D7,100),100*(INT(D7/100)+1),D7) hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks