New to Excel - IF

[ta2606]

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

 

[ta2606]

Thanks Both, figured it out myself, only took me 2hrs though - =IF(D43-AG43>0,0,D43-AG43) is what I needed. Sorry I wasn't explaining it very well, it's all gobbledy gook to me

 

[Joe4]

Thanks Both, figured it out myself, only took me 2hrs though - =IF(D43-AG43>0,0,D43-AG43) is what I needed

Here is a shorter way of writing that:

=MIN(D43-AG43,0)

 

[Scott Huish]

That explains it. The letters were being added by a custom number format and are not actually present in the cell.