IF statement Help

HMiller21

New Member
Joined
Nov 13, 2019
Messages
1
=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
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
38,785
Office Version
365
Platform
Windows
Hi & welcome to MrExcel.
How about
=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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,043
Office Version
365
Platform
Windows
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]
 

Watch MrExcel Video

Forum statistics

Threads
1,095,794
Messages
5,446,530
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top