Help

If statement with blank

Topic Labels: Formulas
555 3
cancel
Showing results for 
Search instead for 
Did you mean: 
a1hart
4 - Data Explorer
4 - Data Explorer

Hi guys

 

need help with this formula if possible, basically the field 'total Pie' needs to return 3 types of values, but if I don;t add the blank condition blank fields default to 'high'

How can I insert the blank statement in?

IF(AND({Total PIE}=BLANK(),BLANK(), if({Total PIE}<=3, "low", if({Total PIE}>=6,"high", "medium"))
3 Replies 3
RdMedia_srl
7 - App Architect
7 - App Architect

you can use this formula, should works

IF(
{Total PIE} = BLANK(),
BLANK(),
IF(
{Total PIE}<= 3 ,
"low",
IF({Total PIE}>=6,"high"
)
)
)

Rodolfo - RdMedia
RdMedia_srl
7 - App Architect
7 - App Architect

if you need also a "medium" value you can modify the formula like this

 

IF(
{Total PIE} = BLANK(),
BLANK(),
IF(
{Total PIE}<= 3 ,"low",
IF({Total PIE}<=10,"medium",
IF({Total PIE}>10,"high"
))
)
)

Rodolfo - RdMedia

amazing that worked!