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
You must be logged in to post a comment.