If and Round Functions

  • Thread starter Thread starter billykiller05
  • Start date Start date
B

billykiller05

Can someone tell me how to use the if and round functions together. My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.
 
Try this:

=IF($A5<1,ROUND(K5-(K5*$A5),2),ROUND(K5-$A5,2))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"billykiller05" <[email protected]>
wrote in message

Can someone tell me how to use the if and round functions together. My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.
 
Back
Top