If AND, OR RRS feed

  • Question

  • I have 2 columns a [sales] column and a [rent column].  Dealers will have a 1 in either or both columns.  I would like to create a calculated column that contains a "T" if either column has a 1 or if both columns have a 1 .  So far this is all i have been able to come up with which leaves out the and sales column.  I have tried everything I can think of but nothing works.

    =IF (AND([RENT] = "1", OR ([RENT] = "1",  [SALES] = "1")),"T", "F")

    Friday, January 23, 2015 4:05 PM


All replies