If and Round Functions
 

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.


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565206

If and Round Functions
 

One way:

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


In article
,
billykiller05
wrote:

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.

If and Round Functions
 

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"
wrote in message
news:billykiller05.2bk78s_1153928416.0754@excelfor um-nospam.com...

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.


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile:
http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565206