Changing Cell Names

[tomtingley]

Hi,

For column 'Rent Type', I want to change all cells that show 'Operating Expenses' to 'Service Charge'.

I'm not sure how to do this.

I want to leave the other cells untouched too.

[DataNath · Accepted solution]

Hey @tomtingley, the following Formula ought to do the trick:

IF [Rent Type] = 'Operating Expenses' THEN 'Service Charge' ELSE [Rent Type] ENDIF

Before:

After:

[ShankerV · Accepted solution]

Hi @tomtingley 

One way of doing this.

IF [Rent Type]="Operating Expenses"
THEN "Service Charge"
ELSE [Rent Type]
ENDIF

Many thanks

Shanker V

[cjaneczko · Accepted solution]

Use the formula tool. 

IF [Rent Type] = 'Operating Expenses' THEN 'Service Charge'  ELSE [Rent Type] ENDIF