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

Reply ↓  Report •

#1
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:

=ROUND((SUMIF($W7,"1",$L7)*$Y$4)/100,0)*100

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question