How to Make "0" in a row = "1"

[DigitalAdam]

Hi all,

I feel extremely stupid asking this question but here goes. 

I am trying to replace "0" in my rank column and make it showcase as "1". 

I know this will create duplicate 1s, however I am trying to make both = to 1 and then i will join them together. 

I'm currently trying a multi row formula with an if statement, IF [RANK] = 0 THEN [RANK] = 1 ELSE [RANK] ENDIF, however no luck. 

Any ideas? I feel like I've tried everything. 

[Luke_C · Accepted solution]

Try this IF [RANK] = 0 THEN 1 ELSE [RANK] ENDIF

I just updated your then clause. Also, you can just use the normal formula tool, no need for multi-row since it's referencing the same row.