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

Just modify Mudraker's formula?

=IF(AND(A1=0,A1<=50),A1*1.2,IF(AND(A150,A1<=100) ,A1*1.5,"Outside
Range"))

ceconik Wrote:
But this formula not work ,example for my problem
I have in A1=14 ,if A1=0-50 formula is A1*1.2
if A1=50-100 formula is A1*1.5


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534542