Excel Formula

[morgre]

I may be dumb! I have been trying to work out a formula for the following eg: If A1 is less than A2 it equals the difference, however if A1 is equal to or greater than A2 it equals zero.

[soybean]

Your notion of how you want A1 to work is not based on sound logic.  Based on what you've said, A1 and A2 contain data, not formulas.  Yet, you go on to say you want A1 to change based on the relationship between A1 and A2.  That doesn't make sense.  You need to use A3 or some other cell for a formula that evaluates A1 and A2.  Try that and then post back if you need help with the formula.

[reddevilggg]

I thought it was more along the lines of -

If A1<A2 then A2 minus A1, else equals 0

[Salmon Trout]

I thought it was more along the lines of -

If A1<A2 then A2 minus A1, else equals 0

It's all in the Excel help.

IF (condition, cell contents if condition is true, cell contents if condition is false)

Below, as you can tell, the formula is in cell A3

[BC_Programmer]

either use IF, as noted above:

=IF(A1<A2,A2-A1,0)

or if you want to be clever:

=(A2-A1)*(A2>A1)

[pum1]

you can see excel tutorial here....Ad Link Removed.

[Salmon Trout]

pum1's link is to a "tutorial" that is actually a disguised advertisement for a commercial report generation package.