Return Blank Cell if condition is not met

[Rich1362]

Hi Community,

Need some help please!

I have this formula:

=IF(AND(AX102="RFT",AY102="RFTE"),"SALARY1",IF(AH102="Ca",IF(AL102="SCRN ***","CALIFORNIA HOURLY MOBILE",IF(AX102="RPT","CALIFORNIA HOURLY","CA HOURLY BENEFITS")),IF(AL102="SCRN ***","OTHER STATES HRLY MOBILE",IF(AX102="PART TIME","OTHER STATES HOURLY","OTHER HOURLY BENEFITS"))))

This formula can apply to 10 cells or 500 cells, depending on the week. I'm trying to get it so that if I set to to apply to 100 cells and only 50 are actually used, then the rest of the cells come back blank.
Right now, if the cells has no data, it comes back as "OTHER HOURLY BENEFITS"

I thought I could just add &"" at the end of the formula BUT that didn't work.

Any thoughts? Thank you in advance

 

[johnnyL]

Try changing the "OTHER HOURLY BENEFITS" to just ""

 

[Sufiyan97]

Try

=IF(OR(AX102="",AY102="",AH102="",AL102=""),"",IF(AND(AX102="RFT",AY102="RFTE"),"SALARY1",IF(AH102="Ca",IF(AL102="SCRN ***","CALIFORNIA HOURLY MOBILE",IF(AX102="RPT","CALIFORNIA HOURLY","CA HOURLY BENEFITS")),IF(AL102="SCRN ***","OTHER STATES HRLY MOBILE",IF(AX102="PART TIME","OTHER STATES HOURLY","OTHER HOURLY BENEFITS")))))

Try

=IF(AND(AX102="",AY102="",AH102="",AL102=""),"",IF(AND(AX102="RFT",AY102="RFTE"),"SALARY1",IF(AH102="Ca",IF(AL102="SCRN ***","CALIFORNIA HOURLY MOBILE",IF(AX102="RPT","CALIFORNIA HOURLY","CA HOURLY BENEFITS")),IF(AL102="SCRN ***","OTHER STATES HRLY MOBILE",IF(AX102="PART TIME","OTHER STATES HOURLY","OTHER HOURLY BENEFITS")))))

Try both of them and see if it works for you

 

[Rich1362]

Try

=IF(OR(AX102="",AY102="",AH102="",AL102=""),"",IF(AND(AX102="RFT",AY102="RFTE"),"SALARY1",IF(AH102="Ca",IF(AL102="SCRN ***","CALIFORNIA HOURLY MOBILE",IF(AX102="RPT","CALIFORNIA HOURLY","CA HOURLY BENEFITS")),IF(AL102="SCRN ***","OTHER STATES HRLY MOBILE",IF(AX102="PART TIME","OTHER STATES HOURLY","OTHER HOURLY BENEFITS")))))

Try

=IF(AND(AX102="",AY102="",AH102="",AL102=""),"",IF(AND(AX102="RFT",AY102="RFTE"),"SALARY1",IF(AH102="Ca",IF(AL102="SCRN ***","CALIFORNIA HOURLY MOBILE",IF(AX102="RPT","CALIFORNIA HOURLY","CA HOURLY BENEFITS")),IF(AL102="SCRN ***","OTHER STATES HRLY MOBILE",IF(AX102="PART TIME","OTHER STATES HOURLY","OTHER HOURLY BENEFITS")))))

Try both of them and see if it works for you

Sufiyan97​

You are my hero! That worked! I needed to make a few adjustments but after that, it worked beautifully!!

Thank you
Thank You
THANK YOU
THANK YOU SO MUCH!

 

[Sufiyan97]

You're welcome
Glad it helped!