Nested If/Then Statement

[dvcastro33]

If:

cell a1 = 10
cell a2 = 15
cell a3 = 20

I am trying to write the following where the value in cell a4 = 5:

if a4 is <=a1 and >=a3, 5, if < a1 10, and if >a3 0

Can someone help me write this statement?

[JBeaucaire]

So try this:

=IF(AND(A4<=A1, A4>=A3), 5, IF(A4<A1, 10, IF(A4>A3, 0, "none")))

[Pete_UK]

Try this:

=IF(AND(A4<=A1,A4>=A3),5,IF(A4<A1,10,IF(A4>A3,0,"not specified")))

You can see that there are some conditions that your description did not cover - you can change the "not specified" message to some other value.

Hope this helps.

Pete

[dvcastro33]

Thank you!!!!!!!!!!!!!

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.