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