ExcelBanter - How can I roundup a cell that already has a formula in it?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I roundup a cell that already has a formula in it? (https://www.excelbanter.com/excel-discussion-misc-queries/95589-how-can-i-roundup-cell-already-has-formula.html)

Timsalive

How can I roundup a cell that already has a formula in it?

I have a formula in a cell (=sumif ) and I want to roundup those numbers and
I get circular issues and I am at a loss.

Any help would be appreciated.

Tim

MarkN

How can I roundup a cell that already has a formula in it?

=ROUND(SUMIF(A:A,"criteria",B:B),2)
--
Hope this helps,
MarkN

"Timsalive" wrote:

I have a formula in a cell (=sumif ) and I want to roundup those numbers and
I get circular issues and I am at a loss.

Any help would be appreciated.

Tim

All times are GMT +1. The time now is 11:00 PM.