Array Formula with ISBLANK

[mxpx]

I'm working on an array formula for dollar amounts and autofilling the necessary phrases based on a financial threshold.

• If amount in K3 is equal to or over $100,000, populate “WALT” in U3
• If amount in K3 is less than $100,000, populate “MIKE” in U3
• If K3 is blank, U3 remains blank

I believe this will be a mix of IF statements and ISBLANK, but the ways I’ve tried haven’t panned out too well. Care to help out an Excel novice?

 

[VoG]

Regular formula

=IF(K3="","",IF(K3>=100000,"WALT","MIKE"))

 

[mxpx]

VoG! Thank you, this worked out great!!

 

[Scott Huish]

BTW, that is not an array formula.

 

[rallcorn]

You didn't say what to do if K3 is something other than a number.

Regular formula

=IF(K3="","",IF(K3>=100000,"WALT","MIKE"))

VOG's formula will return "MIKE" if K3 is anything other than blank or a number over 99,999, for instance if K3 contains the word "junk" U3 will return "MIKE".

This formula will make U3 remain blank if K3 is NOT a number:
=IF(OR(K3="",ISNUMBER(K3)=FALSE),"",IF(K3<100000,"MIKE","WALT"))

 

[mxpx]

HOTPEPPER,

Good point! Obviously I have no idea what I need-- guess the ISBLANK tag was for nothing Which is why I'm here LOL

 

[mxpx]

rallcorn,

I didn't even think about that possibility! Thank you!!

 

[Scott Huish]

Blank won't return TRUE to ISNUMBER:

=IF(ISNUMBER(K3),IF(K3<100000,"MIKE","WALT"),"")