AnsweredAssumed Answered

If statement question

Question asked by dg3321 on Oct 10, 2011
Latest reply on Oct 12, 2011 by dg3321


If statement question


 How do you write an if statement if there are two factors that need to be true in order for the desired result to happen? I have a basic expenses/credits ledger going whereby I have a field for each expense category separate from my expense/credit portal.  In one category field, I want it to total the amount expensed towards this category in the month of January. The way I thought this should go is as follows: Category A amount field:  If (Category = A and Date = 1/*/*, expenses, "") Category A summary field: = Total (Category A amount field) The error I'm getting is at the end of the 1st if statement.  How should this read? Thank you!