=IF(ISNA(A1),"",IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<30 0,Q3,IF(A1<400,Q4,"another
number")))))
--
David Biddulph

"Julie" wrote in message
...
What if A1 is #N/A and you want it to kick back "" blank or 0?


"Teethless mama" wrote:

=IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<300,Q3,IF(A1<400, Q4,"another number"))))

Adjust to suit


"Multiple If, Then statements" wrote:

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x,
then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x
then Q4.

I've tried a bunch but they don't seem to work!!