How to return NULL value/empty cell in an IF statement

[johndoe123]

Hi!

This has probably been asked a couple of times, but i couldn't find the correct thread... Apologies for that!


I often use =IF(X;SomeNumber;"")

When using the resulting sheet as a linked table in PowerPivot it interprets "" obviously as a string and forbids me to set the data type to anything but text. Which means i can't use any aggregate functions in PowerPivot tables (except count and count distinct).

Question:
Is there any way to return NULL values or blank fields as a formulas return value?

Thanks in advance!

 

[Norie]

Why not return 0?

 

[johndoe123]

Why not return 0?

It would change average/min/max for example.

 

[Norie]

Couldn't you exclude 0 from the formula/measure calculating average/min/max?