"if" function problem

  • Thread starter Thread starter ToddBennett
  • Start date Start date
T

ToddBennett

I have too many nested "if" statements in order for a formula to wor
right. What I thought I would do is to make two separate formulas i
two separate cells, and return text to a cell that the formula is no
in. In other words, the formulas would be in cells K1 and L1, but
want text returned to cell D1 based on the outcome of the logic test.

Anyone know how to do this? Thanks,

Tod
 
I have too many nested "if" statements in order for a formula to work

That usually happens when you are not using the right functions for the job, and
are often better off with either VLOOKUP, INDEX&MATCH, SUMPRODUCT etc. Give us
an example of your formula as it currently stands, working or not and we may be
able to suggest a better approach.
 
I have too many nested "if" statements in order for a formula to work
right. What I thought I would do is to make two separate formulas in
two separate cells, and return text to a cell that the formula is not
in. In other words, the formulas would be in cells K1 and L1, but I
want text returned to cell D1 based on the outcome of the logic test.

Anyone know how to do this? Thanks,
Click to expand...

Most of the time, when a person has "too many IF's", there is a simpler way of
solving the problem. That solution frequently, but not always, involves one of
the lookup functions.

So if you could give more information, someone should be able to come up with a
solution.

In your question above, without using VBA, you would need to have a formula in
D1 that would reference K1 and L1.


--ron
 
Hi Todd,
What are the formulas you have come up with so far?

You can probably do this with a VLOOKUP function instead of the nested if.

Or you can set up your IF statements without nesting them:

=IF(condition1,true1,"") & IF(condition2,true2,"") & IF(condition3,true3,"") & ...

Good Luck,
Mark Graesser
(e-mail address removed)
Boston MA

----- ToddBennett > wrote: -----

I have too many nested "if" statements in order for a formula to work
right. What I thought I would do is to make two separate formulas in
two separate cells, and return text to a cell that the formula is not
in. In other words, the formulas would be in cells K1 and L1, but I
want text returned to cell D1 based on the outcome of the logic test.

Anyone know how to do this? Thanks,

Todd
 
Ken,

I took some info from another response and got my problem fixed. Don'
know if it was the best way to do it, but it now works. Thanks,

Tod
 
Back
Top