Multiplication of a number and the result of a formula

Jlind

Hello,

I'm trying to multiply a number and the result of a formula (also a number) but it says "INVALID OPERATION", any ideas please.

Thank you

Genevieve P.

Hi @Jlind

It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?

Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:

=Volume@row * VALUE([Baselined?]@row)

Cheers,

Genevieve

Kelly Moore

Hey @Jlind

Is it possible to share your formulas (both of them)? It is almost impossible without more information for the community to guess what might be causing your error. Also a screenshot of your sheet is always helpful (and usually helps get faster response from the community).

With the additional info someone from the community will be glad to help.

Kelly

Jlind

Sure,

Please see below, the number is the first column and the formula is the second column.

Genevieve P.

Hi @Jlind

It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?

Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:

=Volume@row * VALUE([Baselined?]@row)

Cheers,

Genevieve