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))))
Bookmarks