Excel Formula

Hello There…

I am trying to build a formula in Excel but I’m currently facing a problem. I am not good with excel and therefore would appreciate if any expert could guide me.

I already built in this formula below:

=IF($Q5=””,IF(T5=””,IF(LEFT(X:X,3)=”EPG”,””,”C020 “),””),””)

The formula above works, where if X=EPG, the value will be blank and if it returns other than EPG, it will return C020.

Now, I need to include the OR statement to enable the formula to check for another set of indicator which is “EPF”.

I tried changing the formula as below, unfortunately it returns #VALUE!

=IF($Q6=””,IF(T6=””,IF(LEFT(X:X,3)=OR(“EPG”,”EPF”),””,”C020 “),””),””)

Can someone help me on this? Thank you in advance!

Kind Regards,
– In need of HELP! –