Try
=IF(A4<=50,A1+B1,A1+C1)

Change A4 to the cell you want to test.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ceconik"
wrote in message
...

HELLO OF EVERYBODY.
I would like ask for this :
can i make formula about compare cell for value,and if value= 0
to 50
make A1+B1 ,and if value= 51-100 make A1+C1

Thanks.


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