Can a cell display blank under certain conditions?
 

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.

Can a cell display blank under certain conditions?
 

You want to change F3? That would be a macro...

"DS2005" wrote:

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.

Can a cell display blank under certain conditions?
 

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)


--
-Kaman
The IT dept people call before they call the real IT dept.


"DS2005" wrote:

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.