Just add another IF test:

For a return of blank:

=IF(ISNA(A1),"",IF(...........

For a return of 0:

=IF(ISNA(A1),0,IF(...........

--
Biff
Microsoft Excel MVP


"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!!