• Less than (30) = 6 Month Duration
• Greater than or equal (30) = 12 Month Duration
• Less than 500 = 6 months
• Greater than or equal 500 = 12 Months
• Greater than 1000 = 18 Months
=IF(AND((B10<=499),(C10<30)),"6 MONTHS","12 MONTH")
This is what I have so far.
Bookmarks