Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

multiple criteria if statement

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple Criteria in IF Statement

Multiple Criteria in IF Statement

ResolvedVersion 2010
Edited on Fri 20 Feb 2015, 11:02

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Dashboards for Business Intelligence course

Multiple Criteria in IF Statement

Hi, Can you possible help me with the following?
The formula below needs to be combined to also included the following scenario when (B2,1)="J","J000",(LEFT(B2,2))&"00")

How can I combine logical tests to look at either scenario in one formula?

=IF(LEFT(B2,1)="H","H000",(LEFT(B2,2))&"00")
AND
=IF(LEFT(B2,1)="J","J000",(LEFT(B2,2))&"00")


PLEASE IGNORE THE REQUEST - I'VE FIGURED IT OUT!

RE: Multiple Criteria in IF Statement

PLEASE IGNORE MY ORIGINAL REQUEST

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.