multiply 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

Sandhiya07

Hi @Jlind

Hope you are Good and Safe!

Could you please share the screenshot with column name so that it would be helpful to understand clearly.

And also Is that column name [Baselined] will have "?" question mark at the end?

Thanks,

Sandhiya P

Andrée Starå

Hi @Jlind

I hope you're well and safe!

Try adding the VALUE function to convert the cell with the formula to a number.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!