C
Corey
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?
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?