IF AND Formula Issue
I have to calculate the amount of per diem an associate is to receive. For the most part I can get this to work in Excel with the following formula: =IF((J2-I2)<=7,(J2-I2)*25,IF(AND((J2-I2)>7,TODAY()...
Forum Discussion
I think your last "If" has a "comma" right before your "7" instead of your full boolean expression(In this case, the "If" is trying to check if "ToDays([Hotel Check-Out Date]-[Hotel Check-In Date])" is true or false. Also, I think changing the "AND" to "and" will make the yellow highlight go away.