Hi,
I the example below I am using the formula in L2 =IF(B2=””,””,WORKDAY(D2,-2)) I need to modify this in order that if data in K2 is 0 that it would leave cell L2 empty, any help would be great.
Hi,
I the example below I am using the formula in L2 =IF(B2=””,””,WORKDAY(D2,-2)) I need to modify this in order that if data in K2 is 0 that it would leave cell L2 empty, any help would be great.
Try this:
=IF(OR(B2="",K2=0),"",WORKDAY(D2,-2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks