I need help with an excel formula for a particular column in excel. All argument

Question

I need help with an excel formula for a particular column in excel. All arguments for that specific column. How do i join the arguments in 1 column to give me the right result.

If column V is blank and Column O is less than or equals to zero, its LATE, if not it should be ONtime. Then If column V is not Blank and column Y is greater than or equals to column I, it should be Ontime, if not it should be LATE.

I tried the formula but it gave error that I have too much arguments. Please help

=IF(ISBLANK(V2),IF(O2<=0,"Late","OnTime", IF(NOT(ISBLANK(V2), IF(Y2>=I2,"On Time","Late")))

)

Explanation / Answer

Below is the correct formula to be used. Just copy it and paste in the required excel cell.

=IF(ISBLANK(V2), IF(O2<=0, "Late", "OnTime"), IF(NOT(ISBLANK(V2)), IF(Y2>=I2, "OnTime", "Late")))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.