Check if a column is a certain value otherwise require value input in Excel.

Question

I have an Excel document that contains 8 columns for testing at work like so:

Name           | First Try         | Second Try        | Final Score       | P/F
(Last, First)  | Points  | Percent | Points  | Percent | Points  | Percent |
---------------------------------------------------------------------------------

I have the percentage columns set up to take the previous value (the column before) and divide it by 23, outputting a percentage value to 2 decimal places, unless:

• If that value equals "x", then output a "x"
• If that value equals "v", then output a "v"
• If that value equals "", then output ""

Anyways, what I want to do is for the Points column under second try, I want it to check the Points column in first try and if that value equals "x" or "v", then output "x" or "v" (respectively), otherwise treat that column as a normal input cell (enter a number between 0 and 23). Is this possible using Excel? I know if I write a function for that cell and then enter a value over it, it will clear that function out. I was just wondering if it was possible to use some function like INPUT() as part of my IF() or if what I'm trying to do is just not possible.

So, the data would look like this:

Name           | First Try         | Second Try        | Final Score       | P/F
(Last, First)  | Points  | Percent | Points  | Percent | Points  | Percent |
---------------------------------------------------------------------------------
Some, Name     |      13 |      %% |         |         |      13 |      %% |  P
Another, Name  |       x |       x |       x |       x |       x |       x |  X

So, rather than having to enter "x" into both the first and second try points columns, I wanted to make it easier on other employees that might have to do this so they'd only have to enter the "x" in that first column and it would put an "x" in every other column for them... If I'm approaching this the wrong way, please tell me. :)

Note: Every other column aside from the first and second try points columns already have functions in them to determine the final value for that column. So, I'm just trying to eliminate that second column for them when they enter an "x" or a "y".