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.
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.
One way:
=ROUND(K5-IF($A5<1,K5*$A5,$A5),-2)
In article
<[email protected]>,
billykiller05
<[email protected]> 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.
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
news:[email protected]...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks