Forum Discussion
Help! formula not working
Hello, I am having issues where my formula is not working. It was copied and pasted from another workbook and the only change made was the cell that is referenced, and it is not working. Any advice...
It's not clear what "not working" means. The formula in your screenshot is missing the false argument in the last IF.
You could handle this logic with SWITCH instead:
=SWITCH(E4,"General",1,"Dining",3,"Travel",2,"Excluded",0,"None")