A
Amanda
Hello,
I'm new to IF functions and get cells containing to output correctly,
but when the function encounters a null value/blank cell I get #VALUE!
error.
I think my syntax is off:
=IF(AND(BE2<>""|AA2="MindTap Reader (eBook Only)")|BE2 + 77|)
+IF(AND(BE2<>0|AA2="MindTap Reader (eBook Only w/ associated media)")|
BE2 + 98)+IF(ISBLANK(BE2)|"")
Can anyone help here.
Thanks
Amanda
I'm new to IF functions and get cells containing to output correctly,
but when the function encounters a null value/blank cell I get #VALUE!
error.
I think my syntax is off:
=IF(AND(BE2<>""|AA2="MindTap Reader (eBook Only)")|BE2 + 77|)
+IF(AND(BE2<>0|AA2="MindTap Reader (eBook Only w/ associated media)")|
BE2 + 98)+IF(ISBLANK(BE2)|"")
Can anyone help here.
Thanks
Amanda