IF Function -- Return Null Value Help
 

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

IF Function -- Return Null Value Help
 

The first line should look like...
=IF(AND(BE2<"",AA2="MindTap Reader" ),"eBook Only",BE2 + 77)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)





"Amanda"
wrote in message
...
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

IF Function -- Return Null Value Help
 

"Amanda" wrote:
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)|"")

I think you want:

=IF(BE2=""| ""| IF(AA2="MindTap Reader (eBook Only)"| BE2 + 77|
IF(AND(BE2<0|AA2="MindTap Reader (eBook Only w/ associated media)")|
BE2 + 98| 0)))

Note: I am copying the separator exactly as it appears to me, namely "|".
I assume that is some character that is not in my alphabetic (US English).
The only separators I have ever seen are comma (",") and semicolon (";").
So I would write:

=IF(BE2="", "", IF(AA2="MindTap Reader (eBook Only)", BE2 + 77,
IF(AND(BE2<0,AA2="MindTap Reader (eBook Only w/ associated media)"),
BE2 + 98, 0)))

Also note that ISBLANK() is true only when BE2 is empty (no constant; no
formula). I suspect you get a #VALUE error when BE2 contains the null
string (""). It usually better to test BE2="" instead of ISBLANK(BE2).