IF & Blank Formula not pulling in data

Ask the community Formulas
#1

Can someone assist and ‘teach’ me where I’m going wrong, please?
Trying to pull data from Field B if Field A is blank. Here is the formula I’m currently using, which doesn’t return a value.

IF({Field A} < 5000, {Field A},IF({Field A}=BLANK(),{Field B}))

This formula works to pull data from Field A but Field C is blank, not fulling data from Field B. I don’t get a formula error, the field is only empty.

image

#2

The = BLANK() operator doesn’t seem to be terribly reliable. You could reverse the logic and make a positive check for a value in {Field A} first, and then split the paths on the basis of the existence of a value in {Field A} instead:

IF(
   {Field A},
   IF(
      {Field A} < 5000,
      {Field A}
   ),
   {Field B}
)

Just a heads up, though, this returns nothing if there is a value > 5000 in {Field A}.

1 Like
#3

Perfect! Thank you for the help and for explaining the process.

1 Like