Change it to this, then:

=IF(J10="Yes", B25, 0)

Hope this helps.

Pete

On Feb 16, 7:53*pm, JenOrr wrote:
That worked but if they answer no, it puts #VALUE! in my total column



"JE McGimpsey" wrote:
One way:

In F25:

* *=IF(J10="Yes", B25, "")

In article ,
*JenOrr wrote:

I am trying to set up a sales order, I need to set up a formula that if they
answer yes, then the qty from one column will be transferred to another
column.

Example if they answer yes to glazing in J10, then F25 will equal B25..- Hide quoted text -

- Show quoted text -