-----------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://www.excelforum.com/showthread.php?threadid=53454
-----------------------------------------------------------------------
Question: command "IF&quot

- compare cel
- if A1 =0-5
-----------------------------------------------------------------------

mudraker Wrote:
ceconik

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


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

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.

--
ceconi
-----------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...fo&userid=2806
View this thread: http://www.excelforum.com/showthread.php?threadid=53454