Simple Formula Help
That doesn't sound too hard. One hint I can give you is that for two
not-equal conditions you want not OR but AND -- if G6<"" AND G6<0. Or if
you want to stick with OR, use the positive conditions instead of the
negative: if G6="" OR G6=0, then you want nothing as the result, else you
want the percentage.
As for the rest, tell me what you've tried and I'll pick at it a bit.
--- "Corey" wrote:
I am trying to set a simple formula as follows:
H7: Result of Formula
G6: Original Value ($20.69)
G7: New Value ($10.28)
H7 is Formatted to (%).
I want IF G6<"" or G^<0 then the Percentage to be Saved in Cell H7, else
Nothing to be displayed. Also, if the New Value (G7) is greater than the Origianl
Value, then the Result (H7) to Show a Red Minus(-) Value. I keep getting odd
values that are not correct.
|