Formula Question

Sidonia Posteuca

If two cells have the same value how do I conditional format (or what formula do I use) for that value to show up in another cell?

Andrée Starå

Hi Sidonia,

Is it a specific value or can it be any value as long as it's the same in both cells?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sidonia Posteuca

Yes. It can be any value.

I have it set up so that I have 3 columns: PM % COMPLETE, SUPERVISOR % COMPLETE and % COMPLETE. If the percentages entered in the first two columns is the same (ie. 25%) then I would like that percentage to be replicated in the third column.

Does that make sense?

Andrée Starå

Ok.

Try something like this.

=IF(A@row = B@row; B@row)

The same version but with the below changes for your and others convenience.

=IF(A@row = B@row, B@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?