How to make one cell equal to another

[BillyL14]

Hi

If a cell in column B is equal to zero, how can I make it equal to the numeric value in the cell next to it in column A?

Thank you

[MarqueeCrew · Accepted solution]

@BillyL14 ,

You could use a formula like this:

IIF([Field B] = 0, [Field A], [Field B])

 cheers,

mark

[BillyL14 · Accepted solution]

Hi Mark

thank you very much for that. I just tried that and got the following error

I tried putting quotation marks at each side of the zero but no luck, would you know how to fix that? Thanks again

WL

[Jonathan-Sherman · Accepted solution]

Hi @BillyL14,

This error is caused because you haven't specified a field name (either create a field, or update):

If you fix this you're formula should work perfectly!

IF [Field B] = 0 THEN  [Field A] ELSE [Field B] ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[grazitti_sapna · Accepted solution]

Hi @BillyL14 , you are trying to update the value in Stat.Value where as the error depicts that you have not selected any column. 

Try selecting Stat.Value column then run the formula tool it will work. Please refer to the screenshot.

Thanks.

[BillyL14]

Thank you very much, it works now

[BillyL14]

Thank you very much