Hi

Or maybe shorter still

=500+MIN(2,INT(A1/10))*100

or for 0 if A1 30
=(500+MIN(2,INT(A1/10))*100)*(A1<=30)

--
Regards

Roger Govier


"Biff" wrote in message
...
This one's a few keystrokes shorter:

=IF(ISNUMBER(A1),LOOKUP(A1,{0;11;21;31},{500;600;7 00;""}),"")

Returns a blank "" if A1 30.

Biff

"Biff" wrote in message
...
Hi!

One way:

=IF(ISNUMBER(A1),IF(A1<=10,500,IF(A1<=20,600,IF(A1 <=30,700,"Not
defined"))),"")

You haven't defined what to do if A1 30.

Biff

"Saul" wrote in message
...
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

Thanks in advance!