# I Need to Combine 3 IF Statements

1. ## I Need to Combine 3 IF Statements

I need to combine the 3 IF statements below....HELP!!

=IF D5:D200 = A5, F*H
=IF D5:D200 = A6, E/H
=IF D5:D200 = A7, I=G

2. ## Re: I Need to Combine 3 IF Statements

Welcome to the Forum MrsElston612 !

Formula:
`Please Login or Register  to view this content.`

Change "None of the three" to whatever result you want if none of the three values are matched.

3. ## Re: I Need to Combine 3 IF Statements

Another alternate is Select Case Statements
``Please Login or Register  to view this content.``

4. ## Re: I Need to Combine 3 IF Statements

@saravnepali

LAST WARNING BEFORE TEMPORARY BANNING!!!!

you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

5. ## Re: I Need to Combine 3 IF Statements

Originally Posted by saravnepali
Another alternate is Select Case Statements
This is not a VBA question.

6. ## Re: I Need to Combine 3 IF Statements

try the IFS function. . Google Excel IFS Function , there are plenty of instructive sites ( I cant put up a link as I have not made enough posts yet.

7. ## Re: I Need to Combine 3 IF Statements

Originally Posted by The Rod Baron
try the IFS function. . Google Excel IFS Function , there are plenty of instructive sites ( I cant put up a link as I have not made enough posts yet.
THis is a very good suggestion, since the OP is using 365. The actual formula in this case would be:

Formula:
`Please Login or Register  to view this content.`

8. ## Re: I Need to Combine 3 IF Statements

@ 6StringJazzer

As an aside you raise an interesting question. Does the Office 2019 (your profile) include the IFS, MAXIFS, MINIFS functions as well?

Thanks,
Dave

Edit Never mind. You posted the answer here. Thank you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1