Excel 2003 Question

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

okay what I need help with is this....

=IF(Cell="Text",Cells,Cell) IE... =IF(B22="human",L36:AW37,B22)

what I want it to do is if it sees the " TEXT or text or Text " to then go
to the appropriate cells for the information to be displayed in a different
set of cells on the spreadsheet and I am not getting this done with the IF
function... not certain what function to use
 
I do not think you understand the use of IF!
You cannot redirect output using IF. Iow, you cannot have a formula in say
F1, that will result in output in L36:AW37!

What you can do, is to have a formula in say L36, stating that if the value
of B22 = "human", it should do a calculation, do a vlookup, show nothing, or
something to that effect.

Something like =IF(B22="Human",C22,C23). Or, if B22 = human, then show the
contents of C22, else show the contents of C23.
Or =IF(B22="","",IF(B22="Human", C12*D12,IF(B22="Animal, C13*D13,C14*D14)))

I suggest you post with an explanation, including cell addresses, of exactly
what you are trying to achieve here, then you will get help!

--
HTH

Kassie

Replace xxx with hotmail
 
=IF(Sheet2!L128,FALSE,IF(Sheet2!L129,FALSE,IF(Sheet2!L130,FALSE,IF(Sheet2!L131,FALSE,IF(Sheet2!L132,FALSE,IF(Sheet2!L133,FALSE,IF(Sheet2!L134,FALSE,Sheet2!L203)))))))

returns error #value!
=IF(B22="human",L36) returns a flase to the cell
what I want it to do is display the text that is in the field if it is not
false
 
Hi Andrea,

You cannot add such a lot of if condiions, without telling it what to do!If
any of these statements are true, what should happen, and if they are false,
what should happen! After your last comma, you must tell Excel what to do if
this is true, and add another comma to tell it what to do if these are false.

One way is to list your if's in an OR statement, that is if thin the event
that any one of these are true, the same thing should happen. Excel will
check each condition until it either reaches the end, then go to you false
satement, or until one returns true, in which case it will return your true
option.
=IF(OR(ISERROR(Sheet2!L128),ISDERROR(Sheet2!L129),ISERROR(Sheet2!L130),ISERROR(Sheett2!L131),ISERROR(Sheet2!L132),ISERROR(Sheet2!L133),ISERROR(Sheet2!L134),
what do you want to happen if any one is true, what do you want to happen if
all are false). All this must be in one line.

Otherwise, you must say =IF(ISERROR(Sheet2!L128),do
something,IF(ISERROR(Sheet2!L129),do something,IF(ISERROR(Sheet2!L130),do
something.....IF(ISERROR(Sheet2!L134),do something, do something else)))))))
Also, remember that you can only use 7 such IF's consecutievely.

As far as your other problem is concerned, then

=IF(ISERROR(B22,"",IF(B22="human",L36,"")) should work

--
HTH

Kassie

Replace xxx with hotmail
 
I appreciate the help but ....
=IF(ISERROR(Sheet2!B22,"",IF(Sheet2!B22="human",Sheet2!L117,""))
gets me the following message... you have entered to many arguments for this
function

I am wondering if it might be easier to email the sheet, so you see what I
have at issue here.?
 
Its all about where you put your closing bracket in this example Andrea!
Correct would be
=IF(ISERROR(Sheet2!B22),"",IF(Sheet2!B22="human",Sheet2!L117,"")) After
iserror, you opened a bracket, which must be closed again after Sheet2!B22.
Not to worry, I have received your sheet, and will take a look at it.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top