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

__________________
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

__________________
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.