How to divide (any math operation) a regular number by number in a currency format?

mbsamuel6

Hi,

I have one column written in a currency format. Lets call this column A.

Another column written in a regular number format B.

When I try to create a column formula in Column C like: Column A/ Column B, I get an error called invalid operation.

As you can see in the screenshot below, that formula I have in the Test column errors into "invalid operation".

The "Terms in Months of Contract" column, I tried converting that into both a currency and decimals, but since its a formula column, it looks like it won't let me.

Any ideas to get around this?

Screenshot for help:

mbsamuel6

I said any math operation, but it only gives me the error for divide and multiply

mbsamuel6

I figured it out. You'll have to use the value function.

=value(column a/ column b)