Good Afternoon All,

First time post.

I am building an excel program to make work life easier/quicker and all that good stuff.

I will try to explain my aim as simply as possible (hopefully not confusing to all including myself!).

First, I have a number in A1 638.75 (called a TRANSOM) and another number in A3 573 (called LINK)

A1: 638.75 (TRANSOM)
A3: 573 (LINK)

Between those two numbers there must ABSOLUTELY be a minimum distance of 14.

Example: 638.75-573=65.75

But if it were say: 13, then A1 would be adjusted automatically by 1 make sure there is a distance of 14 at all times and A3 can never ever change.

Example: 560 (A1)-573 (A3)=13 (< really wrong and bad)
Example: 559 (A1)-573 (A3)=14 (< YaY, minimum achieved

A1: Flexible
A3: Can never change
Requirement: Minimum 14 between A1 and A3 (with only A1 changing)

How can I do this? I am at a complete loss.

Please help?

Thank you all for your help and time,
- TwoCoffeeSnobs