If Function with Checkbox

AJandFlavia

I think this is simple formula - but can’t figure it out.

I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have.

If checkbox 1, then take # from extended amount in same row and x1 in that cell.

Does that make sense?

 

Andreas S.

Put in target cell:    =IF(Tickbox1; Source1; "") 

Maybe you have to replace semikolon with comma.

Andrée Starå

Hi,

Try something like this.

=IF(Check@row = 1; Amount@row)

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

=IF(Check@row = 1, Amount@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?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting