Help with =IF statement

[micfly]

Getting confused, in plain English, how can I combine these 3 statements into 1 formula? =if(....)

if m13 is a number then m13*t13
if m13 is a letter then "Included"
if m13 is blank then ""

 

[Ottsel]

Here you go:

=IF(ISNUMBER(M13),M13*T13,IF(ISTEXT(M13),"Included",IF(ISBLANK(M13),"","")))

 

[micfly]

THANKS! I would have never got that

 

[micfly]

Here you go:

=IF(ISNUMBER(M13),M13*T13,IF(ISTEXT(M13),"Included",IF(ISBLANK(M13),"","")))

Hey Bill if you would be so kind, can you help me with one other variation? Not sure how to state this but need a OR statement in there like so:

if m13 is a number then m13*t13
if m13 is a letter OR t13="Included" then "Included"
if m13 is blank then ""

Is this possible? Thanks for any help.

 

[Fluff]

How about

=IF(M13="","",IF(OR(ISTEXT(M13),T13="Included"),"Included",M13*T13))

 

[micfly]

That works - thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.