------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.excelforum.com/showthread...hreadid=534542
------------------------------------------------------------------------
Question: command "IF"

- compare cell
- if A1 =0-50
------------------------------------------------------------------------

ceconik

You have not listed what cell you are testing the value for. I have
used A7 and you have not listed what to do if value greater than 100. I
am leaving result blank if over 100


=IF(AND(A7=0,A7<=50),A1+B1,IF(A7<=100,A1+C1,""))


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=534542