Skip to main content

If statement with blank

  • April 19, 2023
  • 3 replies
  • 39 views
A
Forum|alt.badge.img+2

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

R
Forum|alt.badge.img+10
  • RdMedia_srl
  • Inspiring
  • April 19, 2023

you can use this formula, should works

IF(
{Total PIE} = BLANK(),
BLANK(),
IF(
{Total PIE}<= 3 ,
"low",
IF({Total PIE}>=6,"high"
)
)
)
Rodolfo - RdMedia
R
Forum|alt.badge.img+10
  • RdMedia_srl
  • Inspiring
  • April 19, 2023

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
    A
    Forum|alt.badge.img+2
    • a1hart
    • Author
    • New Participant
    • April 19, 2023

    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!

    Terms & ConditionsAccessibility statement