Putting Formulas Together

[bksparkz]

Good afternoon,

I am having trouble putting formulas together and I am in major need of some help.

I have the following formulas that I need to be put together.

...=IF(OR(N4="N",N4=""),"",LOOKUP(TODAY()-M4,{70}))... the date part is basically anything that is over 70 days from today

...=IF(BH4<=(AB4/2))...

...=IF(AB4-BH4<=5 and IF BH4<10)...

Thank You

 

[Jonmo1]

You've provided no information about the relationship between each formula.
In what way do they need to go together?

Here's one way
=CONCATENATE(IF(OR(N4="N",N4=""),"",LOOKUP(TODAY()-M4,{70})),IF(BH4<=(AB4/2)),IF(AB4-BH4<=5 and IF BH4<10))

 

[bksparkz]

If N4 = N or is blank then leave cell blank
To be true, M4(date) should be more than 70 days from today, and BH4<=(AB4/2), or
To be true, M4(date) should be more than 70 days from today, and AB4-BH4<=5 and IF BH4<10))