scalable if function
Hello
I'm using numbers for mac and I need some help.
I need to apply a percentage depending on an ascending and scalable value. The more value I have, the more percentage I get. This should be the function:
- If I have a value less than 1920$ then the percentage is 50%
- If I have a value more than 1920$ but less than 3840$ then the percentage should be 55%
- If I have a value more than 3840$ but less than 5760$ then the percentage is 60%
- If I have a value more than 5760$ but less than 7680$ then the percentage is 65%
- If I have a value more than 7680 then the percentage is 70%
70% is the maximum percentage.
I've been trying with the IF function but I can only get one step of the function.
Many thanks
MacBook Pro with Retina display, macOS Sierra (10.12.6)