Frequently Asked Questions About Formulas

Top  Previous  Next

How To... > Work with Formulas > Frequently Asked Questions About Formulas

Question

Answer

I see things I want to use in the list. How do I get them into the formula?

Double-click something from the list to get it into the formula.

How do I copy and paste in the formula editor?

To copy, select what you want to copy and press Ctrl+C (Win) z+C (Mac). To paste, position the cursor and press Ctrl+V (Win) z+V (Mac).

I’m having trouble editing a number. I can’t click in the middle of it. What do I do?

With the cursor on either the left or right side of the number, use the arrow keys to move inside the number.

How do I get the “not equals” sign?

Hold down Ctrl (Win) Option (Mac) and press the ≠ button that shows up on the keypad.

Pressing the comma doesn’t work to get to the second parameter of a function. Why not?

You don’t have a correct function. Make sure the function name is colored blue, which means Fathom recognizes it.

Do I have to be careful about uppercase and lowercase?

Except for units, no. For example, stddev works as well as stdDev.

Are string comparisons case sensitive?

No. "New York"="new york" returns true.

Why is it when I type mhz for megaHertz, Fathom doesn’t recognize it?

Units are case sensitive. The abbreviation for megaHertz is MHz with a capital M and capital H.

Sometimes the multiplication symbol doesn’t appear. Why is that?

First of all, Fathom uses a small dot as a multiplication symbol, and you might just be missing it. Second, Fathom doesn’t show a multiplication symbol between a number and a letter. It can’t hurt to type *, but you might not see it.

I’m not sure about Fathom’s order of evaluation. How does it work?

Fathom obeys the normal rules of algebra. But, when in doubt, use parentheses.