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!
IF column is not blank formula
+35Use this formula, and then specify the formatting on the field to include the decimal point and zero:
IF({Column A},8,7)
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.