FALSE Statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheWolverine - 25 Jan 2008 17:48 GMT

Hi,
I have a column of 6 cells C2:C7), I record the lowest value in C8 with
=min(C2:C7). I then record the number of repeats of C8 in cell C9 with
=countif(C2:C7,C8). D1 has a dollar value let's say $12.00. I want to
distribute proper money amounts in D2:D7 whenever one of these cells equals
C8. I had the formula in D2 thru D7 as =if(C2=C8,(D1/C9). That worked fine as
long as there was a value in C2 thru C9. When blank I got #Div0! in the D
cells when corresponding C cells were blank. I thought I had that corrected
with =if(C2=C8,if(C9=0,"",(D1/C9))). Now all my D cells remain blank when my
C2 thru C7 cells are blank. That's good. But, now when C2 has a value, D3
thru D7 show FALSE. Not good. Sorry if I seem to be rambling, I'm new at this.
Question - how do I keep FALSE from showing up, I want all cells without a
value to remain blank.
Thanks for listening.

Reply to this Message

EJ - 25 Jan 2008 23:22 GMT

I may have misunderstood but I think this equation might work...

=IF(C2=$C$8,($D$1/$C$9),"")

Let me know if it works...

> Hi,
> I have a column of 6 cells C2:C7), I record the lowest value in C8 with
[quoted text clipped - 10 lines]
> value to remain blank.
> Thanks for listening.

Reply to this Message

TheWolverine - 26 Jan 2008 16:20 GMT

EJ:
Thanks for trying to solve my dilemma. I tried your suggestion and it
brought me back to my earlier problem when there are no values in any of the
cells, it shows #DIV0'. Basically, im trying to identify the lowest value in
C2:C7 and disperse the money value in D1. If more than one cell in C2:C7 have
the same low value, divide the money equally. If no value in a cell, leave
both C and D cells blank. Again, thank for your help, hope this clarifies
things, if not holler.

TheWolverine (grandkids came up with the ID for me)

> I may have misunderstood but I think this equation might work...
>
[quoted text clipped - 16 lines]
> > value to remain blank.
> > Thanks for listening.

Reply to this Message