EXCEL for the formula: rounding

I am in a cell set up such a formula:= IF (C4> = D4, IF (C4 <F4, 1000 + (C4-D4) * 0.015,1000 + (F4-D4) * 0.015 + (C4-F4 ) * 0.02), 0)

have been the result I want to answer, but the answer is with the small, I hope that this can be rounded to the nearest decimal

pro who knows how to deal with, Please enlighten as soon as possible

^ _ ^

Format Cells, a small number of places is set to 0 can not Yet? = Round (value, 0)
For example, nested into your function is:

= IF (C4> = D4, IF (C4 <F4, round (1000 + (C4 – D4) * 0.015,0), round (1000 + (F4-D4) * 0.015 + (C4-F4) * 0.02), 0), 0)

Leave a Reply