Help! formula not working

Copper Contributor

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 would be appreciated. 2023-11-15_09-58-48.png

1 Reply

@Sammantha23 

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