|FWIW, that makes absolutely no sense. |
With 70% in F5, and the cell containing the formula formatted as a percentage, both of these formulas return 9930%
This formula returns 30%
I can't think of any scenario where placing () around a single hardcoded number will change the result of the formula. Parentheses control the order of operation of the formula. Placing parentheses around a single hardcoded number does nothing to change the order of operation.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03