Multiple IF Functions

Hello,

I tried to make a list of discount with criteria:
>50k up to 45%
30k-50k up to 40%
<30k up to 25%
0 No sales


I only know how to make formula for 3 criteria:

=IF(B2>50000,"up to 45%",IF(B2>30000,"up to 40%","up to 25%"))

But I don't know how to add the 4th criteria, which is if B2=0,"No sales".

Example as attached.

Kindly help.

Thank you.

Hi
try this

=IF(B2>50000,"up to 45%",IF(B2>30000,"up to 40%",IF(B2>0,"up to 25%","no sales")))

It worked Thank you!