I'm trying to calculate different percentages for the same cell. Let's say for arguments sake it's cell
If A1 < 50000 then multiply by 10% If A1 > 50000 then multiply by 12.5% If A1 > 1000000 then multiply by 15%
I'm trying to use an IF formula but it won't let me put three conditions, just two.
How do I achieve this?