Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
=E8-(B9+IF(ISBLANK(G8),0,G8))
I cant get this to work If G8 is empty return 0 else return the value from G8 so that the end result is E8 - B9 if G8 is empty ELSE E8-(B9+G8) if G8 has a value Where did i go wrong? Another problem: E9 to E368 contains decreasing dollar values that eventually fall below Zero. I want to find the first Exx cell at or below Zero and return the A Cell from the same row (which is a date) so for example, H1 I1 Zero Date =Cells.Item(MATCH(E8,E368,-1), 1).Value RowNum Col A Col E 335 Jun 1, 2003 $25.00 336 Jul 1, 2003 $15.35 337 Aug 1, 2003 -1.00 338 Sep 1, 2003 -16.00 so the formula would find Row 337 and return the Date in A:337 which is Aug 1, 2003 and Cell I1 would show that date Thanks Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions |