Multiplying formula results

Faye Hilbourne

I'm creating a cost tracker but am struggling with some multiplication formulas. I've used the IF statement to return an hourly rate i.e. if role is X then hourly rate is £250, this is working as expected. However when I try to multiply an hours column by the rate returned in the IF formula I get an #INVALIDOPERATION error.

So my question is whether it whether it is possible to use the result of a formula in a new multiplication formula. Total hours is keyed in and when hourly rate is keyed in the * formula works but when hourly is returned from an IF statement it doesn't. Am I attempting something that is not possible?

Andrée Starå

Hi @Faye Hilbourne

I hope you're well and safe!

You only need to change the . to , in the Hourly Rate, and then it will work.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

Faye Hilbourne

Thank you for your response. No that didn't work unfortunately.

Andrée Starå

@Faye Hilbourne

Happy to help!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Paul Newcome

It looks like the [Total Hours] is being stored as text. How is that data being populated?