Displaying currency by calculating either a decimal or currency

[SchaneConfer]

I have a table, "Table A", that calculates currency multiplied by a sum of decimals >=1.0. If the dollar amount =0 in the calculation, the amount displayed will be the >=1.0 decimal number. I am using the formula =IF(SUM(F93:G95)=0,FIXED(F86,1),IF(SUM(F93:G95)>0,DOLLAR(SUM(F93:G95)*F86))) to do the calculations and either display the currency or decimal value.

I then have Table A referenced on another tab. On the new tab, I have to sum currency from another table, Table B", and either multiply the sum of the currency from Table B with the decimal output or currency output from Table A.

I have been able to come up with a formula in Table B to calculate the decimal output from table A with the currency in Table B, displaying the result in currency. But, I can't come up with a single formula that will correctly calculate and display currency by either summing currency from Table B and multiplying the two digit number with decimal (x.x) from the results of Table A OR summing the currency result from Table A and the currency from Table B. I've tried, but probably not properly, IF, SUMIF, SUMIFS, OR, AND, with DOLLAR included, and other iterations. Any help? Thanks in advance!