COMBINE TWO FORMULAS

[micfly]

How would you combine these two formulas in to one?

=IF(M13>.5,M13*T13,)
=IF(And(M13>.5(T13=0,"txt")

thanks for any help

 

[jtakw]

Hi,

See if one of these do what you want, otherwise, please clarify your logic:

=IF(M13>0.5,IF(T13=0,"Txt",M13*T13),"")

=IF(AND(M13>0.5,T13<>0),M13*T13,"Txt")

 

[micfly]

=IF(M13>0.5,IF(T13=0,"Txt",M13*T13),"")

You nailed it! This one worked as desired - thank you!

 

[jtakw]

You're welcome, thanks for the feedback, glad it worked for you.