IF ranges

[Jhertilus]

If "E105" is between 0 and 10 I want the E106 to give me "E105", if it is less than 0, I want E106 to give me 0

Can you please help me out with this formula?

[FDibbins]

Next time, please think up a better thread title

maybe...
=if(and(E105>0,E105<10),E105,0)

You did not say what to do if > 10?

[Jhertilus]

Will do

If E105 was greater than 10 I would want E106 to post 0

[FDibbins]

OK what I suggested should do hat for you

[Jhertilus]

Hmm for whatever reason it just gave back E105 ( which was 47 )

[Jhertilus]

wait I think I know what happened.

[Jhertilus]

Still for some reason spits back E105 (47)

[FDibbins]

I tested (again) the suggested forumla, and it works as it should.
=if(and(E105>0,E105<10),E105,0)

Perhaps upload a sample workbook, showing samples of the data you are working with?

[Jhertilus]

It did work. I forgot I was working with percentages so 10 had to actually be .1

thank you!