# IF statement Help

#### HMiller21

##### New Member
=IF(C7="Rosemont University",E7*\$P\$28,IF(C7="Clayborn University",E7*\$P\$28,IF(C7="Branch College",E7*\$P\$28,IF(C7="Eastern Wisconsin University",E7*\$P\$28))))
My issue is that I can seem to remove False from my cells.
Any help is appreciated

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### Fluff

##### MrExcel MVP, Moderator
Hi & welcome to MrExcel.
=IF(OR(C7={"Rosemont University","Clayborn University","Branch College","Eastern Wisconsin University"}),E7*\$P\$28,"?")

Replace the ? with whatever you want if C7 doesn't equal any of those values

#### Joe4

Welcome to the Board!

If you do not want to see "FALSE" if none of the conditions are met, then you need to tell it what to return in that case. So you need to add a FALSE clause in your last check, i.e.
Code:
``[COLOR=#333333]=IF(C7="Rosemont University",E7*\$P\$28,IF(C7="Clayborn University",E7*\$P\$28,IF(C7="Branch College",E7*\$P\$28,IF(C7="Eastern Wisconsin University",E7*\$P\$28[/COLOR][COLOR=#ff0000],""[/COLOR][COLOR=#333333]))))[/COLOR]``
Note, you could also write this like:
Code:
``[COLOR=#333333]=IF(OR(C7="Rosemont University",C7="Clayborn University",C7="Branch College",C7="Eastern Wisconsin University"),E7*\$P\$28,"")[/COLOR]``