Can anyone help with this I suppose easy formula?
I am trying to return a value. For example, </SPAN>=if(left([Text1],1)="N",[Text1],"A"&[Text1]) (this is a powerpivot formula)</SPAN></SPAN>
I want to return Text1 with an N123 or A234. I've noticed that I have blank values in Text1 and is causing to populate “A” instead I want to populate “0” or “Blank” if text1 is blank?
Anyone have any suggestions?
I am trying to return a value. For example, </SPAN>=if(left([Text1],1)="N",[Text1],"A"&[Text1]) (this is a powerpivot formula)</SPAN></SPAN>
I want to return Text1 with an N123 or A234. I've noticed that I have blank values in Text1 and is causing to populate “A” instead I want to populate “0” or “Blank” if text1 is blank?
Anyone have any suggestions?
Last edited:
