I have been trying to build a conditional formula and I cannot get it right. The formula will look at a single status column and based upon the status display various results. I am including a copy of what I am trying to create with the desired results displayed.
1) If complete status = D the formula result should return a status of Verify, If Complete Status = C the formula should return the word Disburse, if the complete status = A the formula should count the number of days between the receipt date and the current date, if the sum of days calculated is 0-44 days the formula result should display Place, if the sum of days is 45-59 the formula result should display Nearing overage,place or return, if the sum of days calculated is > 60 and the quantity for material code starting with any letter; A, B C, D, K or 1 is <299 in the quantity available field the formula result should display Junk, if the sum of days calculated is > 60 and the quantity for material code starting with any letter; A, B C, D, K, or 1 is >299 in the quantity available field the formula result should display Return for credit. if the sum of days calculated is > 60 and the quantity available field for material code starting with a number; 5 is <999 in the quantity available field the formula result should display Junk, if the sum of days calculated is > 60 and the quantity for material code starting with a number: 5 is >999 the formula result should display Return for credit.
Bookmarks