Formula show #ERROR! when Substitute from a Number...

[Jill_Holland]

Is there a problem using a formula field in another formula field ? I have 2 calculated fields that I want to derive from 2 number fields. The 2 raw number fields are {Seeds per g} and {Plan2023}.
I derive an {adjusted Plan} field using 1.1*{Plan2023}. I then want to derive the {wt of seeds required} field using {adjusted plan} /{Seeds per g} but this gives an error for every record.
Even if I make the {wt of seeds required} formula something really simple like {adjusted plan}/2 or 0.5*{adjusted plan} it gives all errors.
I can make the formula just = {adjusted plan} but as soon as I do any numeric operation on it it gives errors.

[Jill_Holland]

OK I sorted it out. The first calculated field used an if statement with an option that if a record was empty, the result was " ". So airtable classified this field as being not numeric, even though it looked like it was. I changed the " " option to 0 and its all OK. Is there an option to have the result being “blank” rather than 0 when a preceding field is also blank ?

[kuovonne]

Jill_Holland:

Is there an option to have the result being “blank” rather than 0 when a preceding field is also blank ?

Leave off the third parameter of the IF function.

IF(
  {adjusted Plan},
  {adjusted plan} /{Seeds per g} 
)

[Jill_Holland]

Thanks kuovonne. I also found there is a Blank() option for formulas.

[kuovonne]

Jill_Holland:

I also found there is a Blank() option for formulas.

Yes, there is. I personally do not find it useful. Other people may find it easier to understand.