adding a round function to a formula in excel

January 16, 2012 at 18:24:10
Specs: Windows 7
Here's my formula: =IF(H15>=$D$8,$D$9*H15,"") the answer it created was 12.5247 per my assignment I need to add a round function that will round the answer to 0. Every time I wirte a formula it gives me wrong answer. If I create a round function in a sep. cell by its self, it works.

See More: adding a round function to a formula in excel

Report •


#1
January 16, 2012 at 18:31:47
If I create a round function in a sep. cell by its self, it works.

What does the separate function look like?

MIKE

http://www.skeptic.com/


Report •

#2
January 16, 2012 at 19:46:38

Report •

#3
January 17, 2012 at 00:15:31
Perhaps He or she want the result to be 12 instead of 12.5247. If i guess correct, try this:

=MROUND(IF(H15>=$D$8,$D$9*H15,""),1)


Report •

Related Solutions


Ask Question