Is there a way to use cell references in an IF() statement?

I know you can use cell references in the "logical_test" clause but is there a way to use them in the "value_if_true" and "value_if_false" clauses? Al the examples of IF() statements have just text strings for what the IF() statement resolves to. I'd like it to resolve to the value in another cell.

For example: =IF(Checkbox = 1, first, second)

Where first and second are cells in the same row.

Find more posts tagged with

Formulas

Comments

Ian

Yes you can.

Example:

=IF([Checkbox]2 = 1, [Column1]2, [Column2]2)

This says if the checkbox is checked in row 2 column checkbox, then return column1 row 2 value

Tom Schlofner

Thanks for the replies. I first tried Ian's solution before I posted and couldn't figure out why I was getting an "UNPARSEABLE" error in the cell. I played around a bit until I found that parentheses around the first clause worked:

=IF(([Checkbox]2 = 1), [Column1]2, [Column2]2)

In the spirit of giving back to the community, I am essentuially implementing a timestamp to record when a checkbox gets checked:

=IF((Checkbox2 = 1), TODAY(), "")

Travis

Hi Tom - The formula you created would show ‘todays’ date when the checkbox was checked. However, ‘todays’ date will change each day to match the current date. If the checkbox is the LAST item that is edited in the cell, you could insert a Modified (Date) System column which will show a timestamp of the last time that row was modified. You can also view the history of the cell to see when the box was checked by right clicking in the cell and selecting View History.