I am using this formula :=IF(B2>=H2,"On Time","LATE") and get the results I want
What I cant figure out is for the cell I have the formula in (J2) to be blank when B2 is blank
I am using this formula :=IF(B2>=H2,"On Time","LATE") and get the results I want
What I cant figure out is for the cell I have the formula in (J2) to be blank when B2 is blank
u can use below formula in J2
=IF(LEN(B2)=0,"",IF(B2>=H2,"On Time","LATE"))
☚ Don't forget to rate person who helped u Click ★
Success Thank you
Here's another one...
=IF(B2="","",IF(B2>=H2,"On Time","LATE"))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks