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.
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.