IF Cell is Blank return Blank

[lisa_swinton]

Hi All
I have a formula to determine if a field should be a Threat or an Opportunity but I want to return blank if there is no data in another cell the below didn't work

=IF(E21,ISBLANK,""),IFS($T21>0,"Opportunity",T21="","",$T21<0,"Threat",$T21=0,"Threat"))

=IFS($T21>0,"Opportunity",T21="","",$T21<0,"Threat",$T21=0,"Threat")) This is the original formula before I started with is blank bit

 

[SanjayGMusafir]

=IF(ISBLANK(E21),"",IFS($T21>0,"Opportunity",T21="","",$T21<0,"Threat",$T21=0,"Threat"))

 

[Fluff]

How about

=IFS($E21="","",$T21="","",$T21>0,"Opportunity",$T21<0,"Threat",$T21=0,"Threat")

 

[lisa_swinton]

=IF(ISBLANK(E21),"",IFS($T21>0,"Opportunity",T21="","",$T21<0,"Threat",$T21=0,"Threat"))

Thank you Sanjay that's worked

 

[SanjayGMusafir]

Glad to help you

 

[Peter_SSs]

I generally do not use IFS as the function tends to be inefficient in that it must calculate very section even if the very first test proves TRUE and the other tests therefore would not be needed. There are usually more efficient ways.
You can also combine some of your checks. So another suggestion is

=IF(OR(E21="",T21=""),"",IF($T21>0,"Opportunity","Threat"))