Forum Discussion
Formula Parse Error: IFS referring to a subtotal cell
I'm trying to use an IFS function to tell the document user who signs off the order based on the subtotal of another cell: Here is my current attempt: =IFS(G25>20000,"Email Budget Holder, Recomm...
Hi
It is generally not good practice to use complex IFS statements as they are difficult to decipher and maintain. You might want to consider using a VLOOKUP with the messages in a table. See example below. The VLOOKUP looks for a value approximate to the one in the table and retrieves the associated message. I hope this helps. Peter