lisa_swinton
New Member
- Joined
- Sep 2, 2022
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
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
=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