Excel Formula to show blank if another cell is blank but has a formula in it

[lisa_swinton]

I have a table the First column returns a value depending on other fields in the table

=IF(ISBLANK($E10)," ",IFS($U10>0,"Opportunity",AND(R10>=0,U10=0,X10>0),"Opportunity",U10="","",$U10<=0,"Threat"))

For the project Number column I'm trying to get the correct formula to return blank if the Risk Nature is blank but what I've done doesn't seem to be working
=IF(ISBLANK($D10),"",$E$4)

This must be really simple if someone can direct me to the solution I'd appreciate it

 

[SanjayGMusafir]

=IF(ISBLANK($D10),"",$E$4)

Rather use this - This way it detects value to be blank

=IF($D10="","",$E$4)

 

[Fluff]

If the 1st formula is in D10 then it will never be "" as you are putting a space in it. Use

=IF($E10="","",IFS($U10>0,"Opportunity",AND(R10>=0,U10=0,X10>0),"Opportunity",U10="","",$U10<=0,"Threat"))

and then use the formula that Sanjay suggested.