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.

Can someone help me out?


--
Corey ....
The Silliest Question is generally
the one i forgot to ask.