If statement to cover range
 

Good day,

I am trying to accomplish is that if the value in cell A1 is between
361-390, I want to return the number 15 or if the value is cell A1 is
between 326-360, I want to return the number 10.

Any help would be great.

Thanks


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=530940

If statement to cover range
 

try this idea
=if(and(a1=361,a1<=360),second if,2,3))

--
Don Guillett
SalesAid Software

"TheLeafs" wrote in
message ...

Good day,

I am trying to accomplish is that if the value in cell A1 is between
361-390, I want to return the number 15 or if the value is cell A1 is
between 326-360, I want to return the number 10.

Any help would be great.

Thanks


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile:
http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=530940

If statement to cover range
 

Perfect.

Thanks Don.


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=530940

If statement to cover range
 

glad to help

--
Don Guillett
SalesAid Software

"TheLeafs" wrote in
message ...

Perfect.

Thanks Don.


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile:
http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=530940