# Multiplying Cells in an IF statement

Options
✭✭

Morning Smartsheeters..

Was hoping someone could shed some light on why this statement isn't working..

=IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75)

I'm trying to multiply two cells based on whether the labour cost is Labour, or Labour O/T.. but I'm getting an INVALID OPERATION FAILURE.

Thank you.

Tags:

• ✭✭
Options

NVM, worked it out :)

the value in the IF statment for the "Supply Price was "£45".. Removing the £ and changing the cell type to a currency fixed it.

• ✭✭✭✭✭✭
Options

Strange!

It should work.

Make sure that you only have numbers in the Supply Price and Quantity columns.

Also, you can simplify the formula by using the @row function.

```=IF(Part@row = "Labour", [Supply Price]@row * Quantity@row)
```

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
Options

Thank you Andree! I managed to get it working by removing the £ in the cells i was multiplying by as you suggested.

Also thank you for the tip on the @row function!

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

Also, you can add the currency through the menubar instead if you still want it to show.

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!