ROUND in a formula

[DrDan]

Hi Mr Excel gurus:

Can't seem to come up with quite the right syntax here. I need to round the results of this formula to the nearest whole number: =$D6-($D6*E6), yielding the resulting rounded number in the same cell. Any help is appreciated!

Thanks

 

[texasalynn]

use
=ROUND($D6-($D6*E6),0)

 

[DonkeyOte]

=ROUND(your formula,0)

 

[DrDan]

Unbelievably quick replies, thank you both!