I am trying to create a formula for if a cell is blank than do this but if not blank then do that.

The formula you provided has a structure that could lead to a #VALUE! error if the references or calculations are not handled correctly. Here’s a revised version of your formula that should work without returning a #VALUE! error:

=IF(ISBLANK($O2),
    IF(ISBLANK($J2), "", TODAY()-$J2),
    IF(ISBLANK($J2), "", $O2-$J2)
)

Key Points to Check:

1. Cell References: Ensure that $O2 and $J2 are correctly referencing the intended cells.
2. Date Calculations: If $J2 contains a date, ensure it is formatted properly as a date. If it is blank, the formula will return an empty string.
3. Formula Structure: Make sure that the parentheses are correctly matched and that there are no additional characters or spaces that could cause issues.

If you still encounter issues, consider checking the values in $O2 and $J2 to ensure they are as expected, and that they do not contain any errors themselves.

References:

• SUMIF, COUNTIF, and COUNTBLANK functions return "#VALUE!" Error