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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,476
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
51,166
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]
 

Forum statistics

Threads
1,078,370
Messages
5,339,789
Members
399,325
Latest member
smilevenki

Some videos you may like

This Week's Hot Topics

Top