IF function for between 2 numbers

[AFawcus123]

I'm having a hard time getting this one right. I've tried IF function and AND w/ MIN & MAX but it's giving me the results I need.
Lets call the reference cell A5 this is the invoice amount for the customer.
And we'll call the results cell A6 this will hold the shipping cost for the customer.
If A5 is 0 then I need A6 to also be 0 or blank
If A5 is between 1 & 349 I need A6 to be $25
If A5 is $350 or higher I need A6 to be 0

Anyone want to take a stab at this?

 

[hagia_sofia]

How about:

=IF(AND(A5>=1,A5<=349),25,0)

or

=IFS(A5=0,0,AND(A5>=1,A5<=349),25,A5>=350,0)

 

[Trebor76]

Another way (though I like hagia_sofia's IFS solution ):

=IF(OR(A5=0,A5>=350),0,IF(AND(A5>=1,A5<=349),25,0))

 

[AFawcus123]

=IF(AND(A5>=1,A5<=349),25,0)

That's a winner!!! Thank you very much

 

[Peter_SSs]

Other variations could be

=25*(MEDIAN(1,A5,349)=A5)

=25*(A5>=1)*(A5<=349)