Help with a logic issue

[Abraxus]

At work we use something called Incubators. They are similar to Excel online or Google Sheets with columns and rows, each row is a record, each column is a specific datatype. Perhaps likening it to an Access table is better.

I am trying to build some logic into one of the fields (FinalField) as follows:

If FieldA has a value, FinalField = FieldA
Else If FieldB has a value FinalField = FieldB
Else FinalField = FieldC

The issue is that FieldA can be empty or contain a value but if it is empty, it evaluates to 0 so I can't use something like
If FieldA>=0 Then...becasue ALL emty fields trigger the TRUE.

0 is a valid, acceptable entry into that field, so I am stumped trying to figure out how to NOT have the empty ones hit the TRUE on the first IF. (Problem probably exists on this IF, too, but I haven't hit it yet, so a solution to one is a solution to the other)

Any suggestions on ways to rethink this? Please note that my formula/function options are VERY rudimentary in this tool.

Appreciate any suggestions!

[HansV]

Can you check whether FieldA = "" ?
Does Incubators have functions such as Excel's ISBLANK and ISNUMBER ?

[Abraxus]

They do, but since it is a decimal field, it still thinks it is a zero. LEN(theField) returns a 1. Ugh.

Solution was to turn FieldA into a text field instead of a numeric field then I could do all the appropriate tests. Makes no sense.