Want to get values from one sheet to another and change info if conditions met?

I am having trouble getting the formual correct to be able to have the information from a cell changed by using an if function to go into another cell. I can get part of it to work but not the other

Below is an example of what I am trying to do

1
2
1
NR
What I want is to return either the number 1 or "NR" in a cell. Currently I can get the 1 to come up but not the "NR"
The formulas I have been trying to use is =if([abc]fw!a1>.9,1,if([abc]fw!a1=NR,NR))

AS mentioned at this stage it is returing a result of 1 in all cells when placed in the new sheet.

Any assistance with this will be much appreciated.

Thank you for that. It seems to work ok and gives me the result I was looking for.

I have one more question you may be able to assist me with. If I then have a cell that is blank I would like to have that cell blank in the new sheet. How do I add that into the formula?

Thanks Crooza. I have put the formula into the file and it works well.

Cheers