numbers
1 Topic
Using IF function - but still want to be able to sum results (as numeric) ...?
Hey! I'm trying to update a rewards program at work where we want to be able to both see if (yes/no) a customer deserves a reward, but also group the level of reward each reacieve in form a points. I've managed to establish Yes/ No by using = IF (Purchase >= 92 , "Yes", "No") E.g. if Purchase is over 92 then Yes they should recieve an award, otherwise no (92% represents the % the limit they need to hi) I've similarly been able to use the If function to group the points = IF(Purchase = 92, "100", IF(Purchase = 93, "200", IF(Purchase = 94, "300", "0"))) This successfully groups the customers into groups based on the % they have hit (e.g. they show up in a table as 92% represents 100 , while 94% represents 300) My problem is however that I cant sum up the to total amount of points collected. As I want to track the total per month - the IF formula does not seem to be beneficial. I would very much appreciate it if someone could suggest another formula where I can still group the data but keep the results as numeric values that can be summarized in a table. Thank you!Solved1.3KViews0likes5Comments