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