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

 

[HighAndWilder]

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

Welcome to Mr Excel

Is it possible to store these values as numbers? e.g. 4m as 4000000 and 250k as 250000.

Do you have lots of cells presented like this?

 

[ta2606]

They are in numbers, sorry

 

[ta2606]

They are in numbers, sorry

I want to be able to copy the formula down

 

[HighAndWilder]

They are in numbers, sorry

So is there always just one A-Z character on the right of the number?

 

[ta2606]

I don't know what a-z means

 

[HighAndWilder]

I don't know what a-z means

Characters a,b,c to z.

 

[ta2606]

I don't know what a-

So is D43>AG43, if it is can it return the neg value
If its D43< AG43, it can return a 0

 

[Scott Huish]

What are the possible letters after the numbers? This is what HighAndWilder is getting at.

Like is 4000, 4000 or 4t.

We need more details please.

 

[ta2606]

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