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.
|