Divide one column by another

Hi

I have 2 columns, both which have numerical values in them. I have a third column in which I want the product of dividing the first column by the second. I have tried this formula.

How do I correct?

Thanks

Accepted answers

Hello @BillyL14 ,

Loose the equal.

Take the equal out

[Net Wt]/[Gr Wt]

Hello @BillyL14 ,

Make sure the formula output type is double. see screenshot below.

Formula Result.PNG

All comments

Remove = sign and it will work.

Hello @BillyL14 ,

Loose the equal.

Take the equal out

[Net Wt]/[Gr Wt]

Hi

Thanks, that worked

However, I would like the answer to come to several decimal places, how can I do that?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703