Donate SIGN UP

Excel Formula

Avatar Image
JessW | 00:50 Thu 21st Aug 2008 | Technology
1 Answers
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?
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by JessW. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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)

Only 1 answerrss feed

Do you know the answer?

Excel Formula

Answer Question >>