"Saul" wrote:
Please help with how to write this formula.
If A1 <= 10 then 500
If A1 10 and <= 20 then 600
If A1 20 and <= 30 then 700

One possibility, in say B1:

=IF(A1="","",IF(A1<=10,500,IF(AND(A110,A1<=20),60 0,IF(AND(A120,A1<=30),700,"More than 30"))))

I've made some additional criteria assumptions to your post for
completeness. The formula above will return "nothing", ie: "", if A1 is empty
or A1 contains a formula evaluating to "", and it'll return the phrase: More
than 30, if A1 contains a number exceeding 30 (or a formula evaluating to a
number exceeding 30)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---