Using "if" with multiple arguments and conditions

[pautavo]

I trying to have the answer but I’m stuck in the last argument.
This is what I have so far:


· 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((C10<30),(B10<=500)),"6 MONTHS","12 MONTH")

 

[BengalMagic]

I trying to have the answer but I’m stuck in the last argument.
This is what I have so far:


· 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((C10<30),(B10<=500)),"6 MONTHS","12 MONTH")

Not achievable, you have conflicting conditions.

 

[Robert Mika]

I trying to have the answer but I’m stuck in the last argument.
This is what I have so far:


· 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((C10<30),(B10<=500)),"6 MONTHS","12 MONTH")

Hallo and welcome to MrExcel.
Which condition will be assigned to B10 and which to C10?

 

[pautavo]

B10= linear feet B10<500=6 MONTHS, 1000>B10>500=12 MONTHS, B10>1000= 18 MONTHS
C10= services C10<30= 6 MONTHS, C10>30 = 12