Subtracting formula issue

[coolhit]

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

 

[Toadstool]

Hi Coolhit,

Like this?

Coolhit.xlsx
	A
10	347000
11	346000
12	-1000
Sheet1

Cell Formulas
Range	Formula
A12	A12	=IF(A11<A10,A11-A10,"")

 

[coolhit]

Hi Coolhit,

Like this?

Coolhit.xlsx
	A
10	347000
11	346000
12	-1000
Sheet1

Cell Formulas
Range	Formula
A12	A12	=IF(A11<A10,A11-A10,"")

This great many thanks