|Either I'm missing something or you're not telling us something. Using your example data and formula, I believe you have this:|
A B C D
1 $56 $68 =B1-A1 =IF(C1>.499,C1/B1,0)
2 $0 $0 =B2-A2 =IF(C2>.499,C2/B2,0)
3 $2 $27 =B3-A3 =IF(C3>.499,C3/B3,0)
If that's correct, the results I get are these:
A B C D
1 $56 $68 $12 17.65%
2 $0 $0 $0 0.00%
3 $2 $27 $1 3.70%
re: "For the 2nd row, because of rounding, the % is high. It should be 0%."
What rounding? I do 0%.
"Then, I want to select all +/- 10% (favorable/unfavorable) and highlighted with blue color. I don't know how to incorporate it in the statement. "
By "statement", I assume you mean "formula".
This is not done within the formula. This is done via a feature called Conditional Formatting. If you look up Conditional Formatting in the Help files or search Google, you should be able to figure out how to write the rule to format the cell based on the result of the formula.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.