Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF column is not blank formula

Topic Labels: Formulas
623 1
Showing results for 
Search instead for 
Did you mean: 

Hi! I would like to set-up a formula where if Column A is not blank, Column B says “8.0”, and if Column A is blank, Columb B will say “7.0”

Is there a formula to do this?

Thank you!

1 Reply 1

Use this formula, and then specify the formatting on the field to include the decimal point and zero:

IF({Column A},8,7)