Forum Discussion
Using Switch Formula but adding an exception
Hi There, I have the below formula that works fine & calculates correctly. =SWITCH(W401=Z$2,TRUE,S401*0.1,FALSE,S401*0.025,) I would like to add an exception to only perform this calcul...
Thanks for that, the formula seemed to build ok but on pressing enter it returns an error
im using
=IF(TEXTJOIN(",",TRUE,U388:V388)="Route Cover Parcel,Reint,Yes","Exclude"SWITCH(W401=Z$2,TRUE,S401*0.1,FALSE,S401*0.025,""))
I get the error thinking im not trying to enter a formula
Cheers
Jim
Jim, at least comma is missed