Excel Formula

[JessW]

I have an Excel spreadsheet and I need a formula that can do the following: "If cell J11 equals J10 then leave blank." Does anyone know what the formula would be?

[ACtheTROLL]

you've just about done it yourself but you've not said what to do if it isn't

=if(j11=j10,"",j11)
just shows a blank cell
or
=if(j11=j10,0,j11)
cell = 0

so
=if(j11=j10,value if it is,value if it isn't)