# Expanding an IF argument to checking condition in 3 different cells

I have a formula that populates cell F2 based on the contents of AA2:

=IF(AA2="","n/a",IF(AA2="Cancelled","n/a",IF(AA2="New","Need sign-off",IF(AA2="No change","n/a",""))))

I would like to expand this formula so that in addition to checking the contents of AA2, it also checks the contents of AQ2 and BG2. That is the only change to the formula that is required...all other elements would stay the same.

Thanks,
Andrea
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Network EngineerCommented:
The following formula should accomplish what you're looking for, if I understand you correctly, and will do so a bit more efficiently (fewer IF statements) using the OR option.

=IF(OR(AA2="",AA2="Cancelled",AA2="No change",AQ2="",AQ2="Cancelled",AQ2="No change",BG2="",BG2="Cancelled",BG2="No change"),"n/a",IF(OR(AA2="New",AQ2="New",BG2="New"),"Need sign-off"))
0
Mechanical EngineerCommented:
A little shorter formula using array constants:
=IF(SUM(COUNTIF(INDIRECT({"AA","AQ","BG"}&ROW(AA2)),{"","Cancelled","No change"})),"n/a",IF(OR(AA2="New",AQ2="New",BG2="New"),"Need sign-off",""))
0

Experts Exchange Solution brought to you by