Nesting a formula in an 'if' statement - conditional values

Adam Lund

I have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column.

I'm trying to use in a IF statement to behave in the following manner and can't get the syntax right.

I'm striving for, in words, "If the Manager column is checked, multiply the [Number of Nights] column in the same row by an amount, if not true, value is $0. This plays into another formula that sums the 'claims' but catches this 'top up' for managers.

=IF([Manager]@row = 1, "([Number of Nights]@row*25)", "0")

Any tips appreciated.

Thanks,

Adam

Purnima Gore

Hi

Use True to make the formula work

=IF(Manager@row = "True", Nights@row * 25, 0)

Hope that helps

Purnima