IF Formula

[Valekk]

Hi, everybody

Can i write IF formula in one cell more than 8 times.
Or is there any other formula that I can replace with IF formula.

Thanks
Valekk

 

[BrianB]

Sometimes lots of IF formulas can be replaced by a lookup table.

 

[Richard Schollar]

Valekk

There may be an alternative formula you can use, but you will have to provide more information on the specifics of what you are wanting the formula to do.

Best regards

Richard

 

[Valekk]

IF Formula Explanation

I have this formula on cell A5

=IF(A1&B1&C1&D1&E1&F1&G1&H1&I1=0,"",
IF(A1>0,I2,IF(B1>0,I2,IF(C1>0,I2,IF(D1>0,I2,IF(E1>0,I2,IF(F1>0,I2,IF(G1>0,I2,IF(H1>0,I2,IF(I1>0,I2""))))))))))

Of course two last formulas are not inputted.

I want to arrange somehow that even if cells A1,B1,C1,D1,E1,F1,G1,H1,I1
are "0", in cell A5 to be “” (Empty)
but if any of cells from A1 to I1 to be larger than “0”
the cell A5 to be equal with number from cell I2.

I hope that you will understand the formula and
What I’m trying to do.

Thanks
Valekk

 

[Valekk]

To Everybody

Thanks for trying halp me

But I find formula that I was looking for

If you are interested the formula is

=IF(A1&B1&C1&D1&E1&F1&G1&H1&I1=0,"",IF(SUM(A1:I1)>0,I2,""))

By