# IF Formula

#### Valekk

##### New Member
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

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### BrianB

##### Well-known Member
Sometimes lots of IF formulas can be replaced by a lookup table.

#### Richard Schollar

##### MrExcel MVP
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

##### New Member
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

##### New Member
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

Replies
0
Views
151
Replies
9
Views
128
Replies
5
Views
114
Replies
6
Views
124
Replies
21
Views
409

1,195,600
Messages
6,010,652
Members
441,558
Latest member
lambierules

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back