I'm trying to write a formula that is technically an IF/OR formula. I have 3 IF statements that need to be considered. I've added each separately to make sure my statement is correct. It's when I pull all three together it blows up. I have 3 columns that are being used in this formula
Day of Month, Current Month and Pay Periods Per Month
=IF([Day of Month]@row >= 30, [Current Month]@row * [Pay Periods Per Month]@row, IF([Day of Month]@row < 15, [Current Month]@row * [Pay Periods Per Month]@row - 2), IF([Day of Month]@row >= 15, [Current Month]@row * [Pay Periods Per Month]@row - 1))
The current error message is #incorrect argument set, I've also had #invalid operation errors as well in my efforts to make this work.. If reordered the formula and tried an IF(OR in the middle (IF(OR(>= 15, < 30). The error seems to occur related to the middle range - which is technically greater than or equal to 15 but less than 30. I can make it work with greater than/equal to 30 and less than 15, but it returns blank for the last IF statement. I tried adding a false answer for this but I think that gives me #unparseable.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!