Return first non-zero value.

  • Thread starter Thread starter George Lob
  • Start date Start date
G

George Lob

I need to know how to return the first non-zero value in a row.

A B C D
1 0 0 5

in D I would like to have a formula like =10/<formula that would return 5>.

Any help would be appreciated.
 
Can you enter an array formula within a non-array formula? This is what I
want to accomplish, but I get an error:

=CHOOSE(MONTH(TODAY()),$C478,$E478,$G478,$I478,$K478,$M478,$O478,$Q478,$S478
,$U478,$W478,$Y478)-INDEX(B479:Z479,MATCH(TRUE,B479:Z479<>0,0))

Thanks for your help.
 
Can you enter an array formula within a non-array formula. What I need to
accomplish is this, but I get an error:

=CHOOSE(MONTH(TODAY()),$C478,$E478,$G478,$I478,$K478,$M478,$O478,$Q478,$S478
,$U478,$W478,$Y478)-INDEX(B479:Z479,MATCH(TRUE,B479:Z479<>0,0))
 
Yes you can but by looking at your formula it is hard to see the logic,
you want to subtract the result from the index formula from the choose
formula?
In any case you need to array enter any formula that includes an array
formula
 
I am trying to get a percentage based on the first value entered (which
could have been done in any month, with prior months being 0) and the
current month value. Anyway, thanks for your help!
 
Back
Top