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.

Another alternate is Select Case Statements

Please Login or Register  to view this content.

@saravnepali

LAST WARNING BEFORE TEMPORARY BANNING!!!!
Administrative Note:

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.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Originally Posted by saravnepali

Another alternate is Select Case Statements

This is not a VBA question.

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.

@ 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.