SchaneConfer
New Member
- Joined
- Jul 16, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
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!
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!