IF AND STATEMENTS

Mhlavin

Hello, 

I am trying to create an IF(AND) statement, but I cannot figure it out.  Any help would be greatly appreciated.

I am trying to write a formula that will check the "at risk" if the the "done" column is not checked and the due date is 7 days before today.

 

Mike Wilday

Try this... The trigger for checkboxes is 1 = checked, 0 = unchecked. When you say 7 days before today, I am assuming you are meaning 7 days ago. If not, then remove the minus from the Today(-7). Hope this helps. When formulating and statements you have to open them (, then list all the criteria (comma separated) and then close the and statement ), before writing out the rest of the IF statement. 

=IF(AND(Done@row = 0, [Due Date]@row < Today(-7)), 1, 0) 

Ken Pavell

I am trying to get the following formula to work but all options I have tried return Unparseable error. =IF(AND(Status@row = 2, CustYr@row = "Year1"), 0.1, (IF(AND(Status@row = 2, CustYr@row = "Year2+"), 0.08, 0.07)), 0.07)

The formula is checking if Status = 2 and if CustYr = "Year1" is true return 0.10, if it is false then I want to execute the second IF/And statement of Status = 2 and CustYr = "Year2+" is true return 0.08 and if false 0.07.

Eric Law

Hello @Ken Pavell

I've corrected your formula, see if it works

=IF(AND(Status@row = 2, CustYr@row = "Year1"), 0.1, IF(AND(Status@row = 2, CustYr@row = "Year2+"), 0.08, 0.07)))