Need help with nested if function ( I think) to return text

August 11, 2017 at 17:51:21
Specs: Windows 7
I don't know how to write the formula to include"allocated not grouped" if the allocation column has a date but the grouping column doesn't.

Allocation Status Allocation Date Grouping Date
Allocated/Grouped_Workable 7/21/2017 7/24/2017
Allocated/Ungrouped 7/21/2017
Unallocated

Formula I'm using
=IF((AND(L2>="", M2>="")), "Unallocated", "Allocated/Grouped_Workable")


See More: Need help with nested if function ( I think) to return text

Reply ↓  Report •

#1
August 12, 2017 at 05:15:45
Please click on the link at the bottom of this post and read the instructions on how to post data in this forum so that the columns line up correctly. Then please edit or repost your data so that it is easier for us to read.

Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Related Solutions


Ask Question