Hi
I am trying to do subtracting but have issue with formula.
Required is keyed in by user in cell A10
Have has formula in cell A11
Short fall has formula in cell A12 which i am having trouble with.
Current i get
Example 1
A10 = 345000 = Require
A11 = 346000 = Have
A12 =1000 = I want it blank.
Example 2
A10 = 347000 = Require
A11 = 346000 = Have
A12 = -1000 = I want it blank.
What i want to achieve is below
A10 = 345000 = Require
A11 = 346000 = Have
A12 = = I want it blank.
A10 = 347000 = Require
A11 = 346000 = Have
A12 = -1000 = I want to show negative figure.
Regards
I am trying to do subtracting but have issue with formula.
Required is keyed in by user in cell A10
Have has formula in cell A11
Short fall has formula in cell A12 which i am having trouble with.
Current i get
Example 1
A10 = 345000 = Require
A11 = 346000 = Have
A12 =1000 = I want it blank.
Example 2
A10 = 347000 = Require
A11 = 346000 = Have
A12 = -1000 = I want it blank.
What i want to achieve is below
A10 = 345000 = Require
A11 = 346000 = Have
A12 = = I want it blank.
A10 = 347000 = Require
A11 = 346000 = Have
A12 = -1000 = I want to show negative figure.
Regards