Conditional Statements

[ebledsoe22]

Hello. I am trying to change the name of a cell based on criteria in another cell. My conditional statement reads as follows, but instead of changing the desired cells to "TN", it changes it to zero. What am I doing wrong?

[Luke_C · Accepted solution]

Hi @ebledsoe22 

Try this: IF [Nexus?] = 'IC' then 'TN' else [ST] endif

Edit - updated formula to have correct name

[ebledsoe22]

@Luke_C Thank you so much!!! It worked. 😊

[Luke_C]

@ebledsoe22 Great! Be sure to accept the solution