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!