Skip to main content

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"))

you can use this formula, should works

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

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"
))
)
)

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"
))
)
)

amazing that worked!

Reply


Terms & Conditions