View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default Returning specific cell if zero

=INDIRECT("B"&MATCH(0,B3:B14,0)+1)

"Bradley" wrote:

I am trying to write a formula to return a cell if zero is listed.

My example is

CURRENT MONTH 4776

JAN 4308
FEB 4388
MAR 4688
APR 4776
MAY 0
JUNE 0
JULY 0
AUG 0
SEPT 0
OCT 0
NOV 0
DEC 0

The CURRENT MONTH will always list the cell above the first zero listed,
since MAY is the first zero listed then April would be listed in the CURRENT
MONTH. I have tried IF statements. I am not very good yet with ARRAYS and
INDEXS.

Any help would be great!!!

Thanks
Bradley