Need help creating a column formula only if values are entered

annamo

I need to create a formula for the OVER/UNDER column only if there are values in the 2025 BUDGET and COST TO DATE.

annamo

Never mind I figured it out

=IF(ISBLANK([Cost to date]@row), "", [Cost to date]@row - [2025 Budget]@row)

RAdamowicz

Hi! How is the formula that is returning an #INCORRECT ARGUMENT error currently formatted?

annamo

I have tried a few variations but this is what the one for that line

=IF(NOT(ISBLANK(SUM([Cost to date]@row - [2025 Budget]@row))))

annamo

Never mind I figured it out

=IF(ISBLANK([Cost to date]@row), "", [Cost to date]@row - [2025 Budget]@row)

Marcela

Hello @annamo,

I'm glad you figured it out.

Thank you for posting your solution!