Formula: If multiple of 3
Solved
Aude
-
Lentzouille2 Posted messages 1000 Status Member -
Lentzouille2 Posted messages 1000 Status Member -
Hello everyone and best wishes!!
I'm reaching out to you because I want to solve the following problem:
In my file, I have 2 dates in 2 columns, and in column H, I have the number of working days between the 2 dates, on each row.
I would like to know, in column I, if the number of working days in column H on the same row is a multiple of 3 (3, 6, 9, 12, 15.......)
If H is a multiple of 3, indicate "NEED SMS"
If H is not a multiple of 3, leave I blank.
Thank you very much in advance ;))
I'm reaching out to you because I want to solve the following problem:
In my file, I have 2 dates in 2 columns, and in column H, I have the number of working days between the 2 dates, on each row.
I would like to know, in column I, if the number of working days in column H on the same row is a multiple of 3 (3, 6, 9, 12, 15.......)
If H is a multiple of 3, indicate "NEED SMS"
If H is not a multiple of 3, leave I blank.
Thank you very much in advance ;))
