Formula with conditons
 

Hey Dham, can you clarify?

From your example, 295 and 1 is 296, how did you return 6?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554755

Formula with conditons
 

If I understand correctly, Dham wants to solve for x in the equation:

MOD(295+x,300)=1.

In other words, what has to be added to 295 to get 1 if we are
resetting to zero when it reaches 300.

MOD(295+6, 300)=1 makes sense for the example given.

This however, is not solvable without more information. If you know
that 300 was only reached once before resetting to 0, then the formula
would be
C1=B1+300-A1.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=554755