Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill a blank cell with a value using if conditions | New Users to Excel | |||
if conditions in 2 cell correct then display third cell | New Users to Excel | |||
returning blank cell when conditions not met | Excel Worksheet Functions | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions |