# Using a formula to checking if a cell has a value

**URL:** <https://air.tableforums.com/t/using-a-formula-to-checking-if-a-cell-has-a-value/76>\
**Category:** Tips & Tricks\
**Created:** [January 5, 2023, 6:34pm UTC](https://air.tableforums.com/t/using-a-formula-to-checking-if-a-cell-has-a-value/76 "2023-01-05T18:34:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\
**Post date:** [January 5, 2023, 6:34pm UTC](https://air.tableforums.com/t/using-a-formula-to-checking-if-a-cell-has-a-value/76/1 "2023-01-05T18:34:51Z")

</div>

For most field types, you can check if a cell has a value with an `IF` function.

```auto
IF( 
  {Date},
  DATETIME_FORMAT({Date}, "MMMM D, YYYY h:mm A"
)

```

Notice that you can simply use the field name _without_ comparing the field value to `BLANK()` or an empty string `""`.

However, if the field is a number field, and zero is a valid value, you need a different technique. Comparing the number to `BLANK()` won’t work because Airtable thinks that `BLANK()` is the same as `0`. Instead, you can turn the field into a text string to see if there is a value.

```auto
IF(
  {Number} & "",
  "✔️"
)

```

If you want to see if a set of fields all have values, use the `AND()` function.

```auto
IF(
  AND(
    {Date},
    {Number} & ""
  ),
  DATEADD({Date}, {Number}, 'days')
)

```

 ![image](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/6333c0f3472d9aeeb514a07118ad5a0aff1a07f0.png)