I am trying to see if something is greater or less than, so say I have £4m and want to see if it is higher or lower and how much higher than say £250k but return a zero if it is higher
In cell one - 4m
In cell two 250k
If cell one is higher I want the cell to show as neg and how much difference
If cell two is higher I want it to return a 0
In cell one - 4m
In cell two 250k
If cell one is higher I want the cell to show as neg and how much difference
If cell two is higher I want it to return a 0