I need a formula.
Budget: $10 – $30 USD
If column "F" has "Break" AND column "D" is greater than 0:00:20:00", I want a result that says "Check". If false, then "Normal".
I was trying to use "IF(AND(D:D>=TIMEVALUE(0:00:20:00),F:F="Break","Check"", "Normal"))
However, the Excel Document didn't recognize the formula? Can you assist.
I was trying to use "IF(AND(D:D>=TIMEVALUE(0:00:20:00),F:F="Break","Check"", "Normal"))
However, the Excel Document didn't recognize the formula? Can you assist.