IF statement issues

[cynthi263]

I need to adjust the below to say if what is in orange is >=12 then return a value of "monthly"...right now it works how it is and brings back a value of 12, instead of 12 i'd like it to say monthly. I have tried adding another if statement but i keep getting 0 or errors. It's probably something small or out of order but i cannot figure it out.


=IF(M2="Y",ROUND((J2-H2+1)/30,0),"ANNUAL")

 

[DanteAmor]

Try this:

=IF(M2="Y",IF(ROUND((J2-H2+1)/30,0)>=12,"monthly","It is less than 12"),"ANNUAL")

 

[BlueHornet]

The general format for nested IFs, when you're examining one condition first and then (if that one is true) another condition is:
=if( FIRST condition, if( SECOND condition, BOTH conditions true, FIRST condition true AND SECOND condition false), FIRST condition false AND SECOND condition not evaluated)

So I'm guessing that what you want is:
=IF(M2="Y", if( ROUND((J2-H2+1)/30 >= 12, "Monthly", 0) ,"ANNUAL"))
But I'm really guessing, because the term you left us in orange seems to be an entire IF scenario on its own, with the trailing ",0" term.

Alternative structures, for different logic can look like:
=if( and( FIRST condition, SECOND condition), BOTH are true, EITHER is false)
and so forth

 

[cynthi263]

Thank you both! i got it to work with your help!

 

[DanteAmor]

Glad we could help & thanks for the feedback