Solved Rounding a SUMIF formula

April 9, 2019 at 10:59:36
Specs: Windows 7
I need to round the answer to the formula =SUMIF($W7,"1",$L7)*$Y$4 to the nearest 100. How do you combine the two?

See More: Rounding a SUMIF formula

Report •

April 9, 2019 at 14:05:45
✔ Best Answer
Do you want to ROUNDUP() or ROUNDDOWN() to the nearest 100?

This uses the ROUND() function:



message edited by mmcconaghy

Report •
Related Solutions

Ask Question