Forum Discussion
Need help with multiple IFs formula
I can't do this with a traditional IF formula. So, I've been trying to work out the IFS formula. It seems this should work but, something is off somewhere: =IFS(G19="Buy", ((H19*F19)*-1), G19="Se...
Unfortunately, I get the same "#Name?" error with the switch formula as i do with the IFS formula I posted.
IFS() and SWITCH() are available since Excel 2019.