How to include 2 separate IF and ISBLANK functions in 1 cell? [closed]
Is this possible? I've searched online and tried shifting things around, but all methods have failed. I want the function to follow the following steps:
- If I30 is "A" use J30
- but if J30 is blank, leave field blank
- If I30 is not "A", use K30
- but if K30 is blank, leave field blank
Below are my attempts:
=IF(AND(I30="A",IF(AND(ISBLANK(J30),"",J30)),K30))
=IF(AND(I30 = "A",(ISBLANK(J30),"",J30),IF(AND(ISBLANK(K30),"",K30))))
=IF(AND(I30<>"A",(ISBLANK(J30),"",K30)))
=IF(AND(I30<>"A",(ISBLANK(J30),"",K30~J30)))
=IF(I30<>"A",1,3)
The 2nd to last function always changes the ",J30" at the end to "~J30", btw.
To be clear, this function for ISBLANK works just fine:
=IF(ISBLANK(J30),"",J30)
Edit: Corrected the ISBLANK function.
is incorrect and yields probably
Err:509
Check
=IFS(I30="A";IF(ISBLANK(J30);"";J30);I30<>"A";IF(ISBLANK(K30);"";K30))
:( I meant:
Yours worked, btw.
Edit: Finally got it.