Laravel · · 1,217 views

Excel test


=AND(
R14 <> "",
OFFSET(R14, 1, -1) <> "",
NOT(ISNUMBER(OFFSET(R14, 2, 0))),
OFFSET(R14, 1, 0) <> "R/O",
NOT(ISNUMBER(R16)),
R17 <> "R/O",
IF(R14 < OFFSET(R14, 1, -1),
ABS((R14 + 1 - OFFSET(R14, 1, -1)) * 24) < 12
)
)

10 in arow

=AND(COUNTA(OFFSET(W55, 0, -10, 1, 10)) = 10,
COUNTIFS(OFFSET(W55, 0, -10, 1, 10), ">0", OFFSET(W55, 0, -10, 1, 10), "<1") = 10,
COUNTIFS(OFFSET(W55, 0, -10, 1, 10), "<>0") > 0)

=IF(E4 < TODAY(), "Expired", IF(E4 <= TODAY() + 30, "Attention", "Current"))
Contact

Want to get in touch?

If you want to talk about a project, a software or IT role, something you have built, or something you want to improve, send me a message.

I read the messages myself.

Thank you. Your message has been sent.