I need to write a formula or function that will do the following:

If the Value in Column W is between < .5 and .1, then the Value of U should be entered into the formula field (Column J). If U is not between the range, then the field (Column J) should be blank.

If anyone can help I would greatly appreciate it.

Hi and welcome
Perhaps
=IF(and(W1>0.1,W1<0.5),U1,"") entered in J1

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I appreciate the help but that didn't work. I assume that as part of the formula you wrote the value of U should be between the quotes. So for example, my value in U is 2440 and my value in W is .80.

So if I go by your formula it should read:

=IF(and(W1>0.1,W1<0.5),U1,"2440")

Is that correct?

The formula proposed does the following
1. Is W1 between 0.1 and 0.5 ?
If Yes the value of U1 is entered in J1
if no, J1 remains empty

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your help. I was able to simplify what I needed.