Formula for IfBlank

Kimberlee Adam

I'm still stuck on this. I know it's got to be something so simple that I'm missing. But you can see that the blank rows are not calculating correctly.

Thank you!

David Joyeuse

Hi @kimberlee.adam89166

If I understand your formula right, it should be like this:

=IF(OR(ISBLANK([Actual - Cap]@row), ISBLANK([Actual Burndown]@row)),[Forecast - Cap]@row, [Actual Burndown]@row - [Actual - Cap]@row)

If either Actual Burndown or Actual - Cap are blanked, then display Forecast - Cap. Otherwise do Actual Burndown - Actual Cap.