little change to MOD function

[Ady4um]

Hello.

Straight to my situation.

A1: positive integer
A2: positive integer
A3: MOD(A1/A2,1)
A4: 1*(A3=0)
A5: A3+A4

The above MOD function in A3 returns values between:

0 < = (A1/A2) < 1

In A5 I manage to have:

0 < (A1/A2) < = 1

Which is what I want.

That result in A5 is almost the same as the MOD function in A3, except that when A3 results in 0 (zero), A5 results in 1 (one).

I don't really need A4 nor A3, so I could combine them as:

A6: MOD(A1/A2,1)+(MOD(A1/A2,1)=0)

There should be a simpler (or alternative) way to get the same result, but I couldn't find it. Ideas?

Thank you in advance.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=581135

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).