This is what im given

Money spent by member ---

>=2500 gets you 10% cash back

>=5000 you get 15% cash back

>10000 you get 20% cash back

F6 is the first amount for "money spent" by a member

this is what I tried and it never worked

IF(IF(IF(IF(F6<2500,"0"(F6<=4999,F6*0.10(F6<=9999,F6*0.15(F6>=10000,F6*0.20))))