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


"Andrea" wrote:

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