The name 'blank' wasn't recognized expression error

[DjDon]

Hi,

Hopefully this is simple:  why does this formula error with "the name 'blank' wasnt recognized"?

=if [Age yrs] < 2 then
     [Age yrs] * 49.3
else if [Age yrs] > 2 and [Age yrs] < 3 then
     [Age yrs] * 33.1
else if [Age yrs] > 3 then
    [Age yrs] * 4.9
else
     blank()

[amitchandak · Accepted solution]

@DjDon , In power query you have null. or you can leave else part

if [Age yrs] < 2 then
[Age yrs] * 49.3
else if [Age yrs] > 2 and [Age yrs] < 3 then
[Age yrs] * 33.1
else if [Age yrs] > 3 then
[Age yrs] * 4.9
else
null

/////////// or

if [Age yrs] < 2 then
[Age yrs] * 49.3
else if [Age yrs] > 2 and [Age yrs] < 3 then
[Age yrs] * 33.1
else if [Age yrs] > 3 then
[Age yrs] * 4.9

[DjDon]

That works great - thanks!!  Question, are null and blank treated the same in column summation or other formulas?  Thanks again..