Hello,
I have a rather unique situation that I am having trouble with. Was hoping
someone could point me in the right direction. Here is the situation:

I have a data spreadsheet that different personnel input data into. The
columns affected are J and AM. If there is a value (1 or greater) in Column
J, then there can be no values in Column AM. Otherwise, if there is no value
in Column J (empty cell), then Column AM can be 0, 1, or 99 only. Note that
Column J is blank, or empty, and not "0".

Does anyone have any advice on how to set up the formula for this?

Thank you!!