|re: No it's not a typo.|
If Q244=1 then enter 1, if Q244=1 then enter 1 in cell R244
That's not a typo? Why do you repeat the words "If Q244=1 then enter 1" twice?
re: "if the value in Q10=3 (or 1, or 2, etc.) then to put a 1 in cell R10 and zero out Q10"
The first part is easy:
In R10 enter:
=IF(Q10 = 3, 1, "")
However, as I said earlier, you can not use a formula to "zero out" a cell after entering a number in it.
The only way to zero out a cell that after manually entering a number in it is with VBA. However, if you delete the value in Q10, then the value in R10 will change also - unless you use VBA to also lock the value in that cell.
Why can't you use something like COUNTIF to get the values you need?