Can a cell display blank under certain conditions?

D

DS2005

I need help with a formula...

If F3 is eqal to F2, i need F3 to display a blank cell. If F3 is not equal
to F2, I need the cell to display the sum of D2, E2, D3.
 
K

Kaman

Uh...what you're describing is a akin to a paradox or circular logic. Assume
you have '10' in F2, then you must have '10' in F3 for it to equal (but you
don't; remember, you have the formula in that cell). But even if you could,
then the formula would change F3 to blank/nothing/zero, which wouldn't match
F2 anymore, in which the formula would then change F3 to the sum of D2/E2/D3.
In either case, you would get sum.

You need to do your formula in another row or column, say F4, that compares
F2/F3 and returns the desired result. In Cell F4 or any other cell except
F3/F2/D2/D3/E2 you would type: =IF(F3=F2,"",E2+D2+D3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top