This is a weird one. I don't even know if something like this is
possible. That said, here is my issue.

I have cell J6=205. Now, I want J7 to change based on information in
cell C5.

Here is what I am trying to do.
-The user can enter "LFL" (lot-for-lot) in C5 and then J7=J6. (or some
number, say 0, could be used in place of LFL I guess)
-The user could also enter some integer, say "100" in C5 and then J7
can only be multiples of 100. To cover the 205 in J6, it would need
300 then in J7.
-The Final thing they could enter is something like "100+" in C5 in
which case the minimum vlaue of J7 is 100, but can be anything over
that, so 205 would end up in J7.

Is there any possible way to do this? I know it is a tough problem,
but any help would be great.

Thanks,

DtTall