How to combine two formulas in excel

[WWW8084]

Can anyone assist me to combining the following two formulas in one cell?

Formula#1

=IF(X3<=0.999,"MC 0 - 1",IF(X3<=2.999,"MC 1 - 3", IF(X3<=8.999,"MC 3 - 9",IF(X3<=23.999,"MC 9 - 24",IF(X3<=49.999,"MC 24 - 50",IF(X3>=50,"MC Above 50" ))))))

Formula#2

=IF(MONTH(F3)=4,"NEW RECEIPT",IF(SUM(J3:R3)=0,"9month no dispatch","6month no dispatch"))

Combined Formula:

please paste here.

Regards.

 

[steve the fish]

Hi. What do you mean by combine? I notice there is no false argument for if X3>=50. Is that where you want the 2nd formula adding?

 

[WWW8084]

I wish to joint both of these formula.

 

[WWW8084]

the second formula should take place after IF(X3>=50,"MC Above 50" starting point of second formula

 

[steve the fish]

See if this is it?

=IF(X3<=0.999,"MC 0 - 1",IF(X3<=2.999,"MC 1 - 3", IF(X3<=8.999,"MC 3 - 9",IF(X3<=23.999,"MC 9 - 24",IF(X3<=49.999,"MC 24 - 50",IF(X3>=50,"MC Above 50",IF(MONTH(F3)=4,"NEW RECEIPT",IF(SUM(J3:R3)=0,"9month no dispatch","6month no dispatch"))))))))

 

[steve the fish]

Or this maybe?

=IF(X3<1,"MC 0 - 1",IF(X3<3,"MC 1 - 3", IF(X3<9,"MC 3 - 9",IF(X3<24,"MC 9 - 24",IF(X3<50,"MC 24 - 50",IF(X3>=50,"MC Above 50"))))))&" "&IF(MONTH(F3)=4,"NEW RECEIPT",IF(SUM(J3:R3)=0,"9 month no dispatch","6month no dispatch"))