Eliminate #N/A Error

[Bedford]

Using a formula that is giving an error #N/A when cell F17 is empty but I'm looking to simply have it give a blank in the cell. Can anyone offer a suggestion to help out.

=@IFS(AND(F17>=300,F17<=600),2,AND(F17>600,F17<=1100),3,AND(F17>1100,F17<=1600),4,AND(F17>1600,F17<=2100),5,AND(F17>2100,F17<=2600),6,AND(F17>2600,F17<=3000),7)

Thank you in advance.
Doug.

 

[Fluff]

How about

=IFS(AND(F17>=300,F17<=600),2,AND(F17>600,F17<=1100),3,AND(F17>1100,F17<=1600),4,AND(F17>1600,F17<=2100),5,AND(F17>2100,F17<=2600),6,AND(F17>2600,F17<=3000),7,1,"")

 

[Bedford]

How about

=IFS(AND(F17>=300,F17<=600),2,AND(F17>600,F17<=1100),3,AND(F17>1100,F17<=1600),4,AND(F17>1600,F17<=2100),5,AND(F17>2100,F17<=2600),6,AND(F17>2600,F17<=3000),7,1,"")

That did the trick! Thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Bedford]

You're welcome & thanks for the feedback.

My Pleasure.

 

[Bedford]

You're welcome & thanks for the feedback.

Hope I'm not over extending my good fortune and your generosity, I have another formula that is likewise giving an #VALUE! error when cell D15 is empty, however it might also do so if other dependent cells are also empty?

=@IFS(F27<3," ",D15<=600,D15+F15+220-F28,D15>600,D15+F15+320-F28)

Any thoughts?
Again, thank you in advance.

 

[Fluff]

Maybe

=IFS(F27<3,"",OR(D15="",F15="",F28=""),"",D15<=600,D15+F15+220-F28,D15>600,D15+F15+320-F28)

 

[Bedford]

Maybe

=IFS(F27<3,"",OR(D15="",F15="",F28=""),"",D15<=600,D15+F15+220-F28,D15>600,D15+F15+320-F28)

Absolutely perfect. And your response helped solve a similar error by using similar code., this one now also is without error; '=IFS(F27<5,"",OR(D15="",F15="",F28=""),"",D15<=600,D15+F15+220-(F28*2),D15>600,D15+F15+320-(F28*2))