Hi Helpers,
I'm using function switch trying to achieve that if the source field is blank then the target field (where the function sits) remains blank too. Using the below function I get #N/A currently when F2 is blank, I would like the cell to be blank instead of #N/A. I was trying to use BLANK() and ISBLANK() as arguments but did not work. Can you advise how to have the field empty?
Thanks
I'm using function switch trying to achieve that if the source field is blank then the target field (where the function sits) remains blank too. Using the below function I get #N/A currently when F2 is blank, I would like the cell to be blank instead of #N/A. I was trying to use BLANK() and ISBLANK() as arguments but did not work. Can you advise how to have the field empty?
Excel Formula:
=SWITCH(F2,"S","S","P","P","VA","VX","P;S;VA","ALL","","")
Thanks