If statement with blank

[a1hart]

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

[RdMedia_srl]

you can use this formula, should works

IF(

{Total PIE} = BLANK(),

BLANK(),

IF(

{Total PIE}<= 3 ,

"low",

IF({Total PIE}>=6,"high"

)

)

)

[RdMedia_srl]

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"

))

)

)

[a1hart]

amazing that worked!