I'm trying to calculate different percentages for the same cell. Let's say for arguments sake it's cell `A1`

:

```
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?

`=VLOOKUP(A1,E:F,2)*A1`

and be easier to extend should you wish later to add additional breakpoints. – pnuts Apr 10 '13 at 13:27