Multiply data from a formula column

[KevinB (Kevin Barlow)]

DISREGARD THIS. PROBLEM FIXED BY NOT HAVING IT AS A DOLLAR VALUE. REMOVED THE $ AND NOW IT WORKS.

Hi,

I have a column that displays a price based on a formula and lets call this column “A”.
I also have column “B” with a number I typed in myself for each cell in the column.

I then created another column that will multiple Column A and B . {Column A}*{Column B}

It says one of the parameters is invalid. It worked before though when I had column A as a number I typed in (before making it a formula). Is there a work around?

Thanks,

Kevin

[DanIngham-IOI (Dan Ingham IOI / BPX)]

Hi Kevin
this should give what you need, just used the $ in the column options
Formula in the last column
MULTIPLY({Formula 5},{B})

let me know
Many thanks in advance
Dan