IF Formula for values and cell locations

[johnnynstars]

I am in need of a formulas in Cell O4 for the following:

100 in L4. 5 in N4. If L4 is less than or equal to 100 value to stay as N4. If L4 is greater than 100 but less than 500 O4 to show 80% of N4. If L4 is greater than 500 but less than 1000 O4 to show 70% of N4

in cell P4

25% of N4 if L4 is greater than 100 but less than 500

In cell R4

15% of N4 if L4 is greater than 500 but less than 1000

Therefore at less than or equal to 100 cell O4 is 100% of N4.
If L4 is greater than 100 but equal to or less than 500 cell O4 is 80% of N4 and cell P4 is 20% of N4.
If L4 is greater than 500 but equal to or less than 1000 cell O4 is 70% of N4 and cell P4 is 20% of N4 and R4 is 10% of N4.

I look forward to your help.

 

[iliace]

What happens to P4 if L4 is greater than or equal to 500, or less than or equal to 100?

What happens to O4 and R4 if L4 is greater than or equal to 1000?

What happens to R4 if L4 is less than or equal to 500?