Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return null | Excel Worksheet Functions | |||
how to get a function to return a null value that passes the ISBL. | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
return a " " for null values | Excel Worksheet Functions |