On 7/29/07, Harold Fuchs <[EMAIL PROTECTED]> wrote: > Scott Castaline wrote: > > 1.I'm trying to write a formula in a cell that based upon 3 or 4 > > possible situations in one cell will determine which of 2 values to > > put into the cell. I have gotten it to work partially, but can't seem > > to get it to work all of the time. The formula currently is: > > =IF(C16="State Funds";135;0)
> For part 1 use the formula =IF(LEFT(C16;11)="State Funds";135;0) which > tests the 11 left-most characters of C16. That's a lovely trick. I like it. > For part 2, please hope someone else can answer ... > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
