Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Hi,
I am using a formula to capture the top 5 brands. a b c d e However, for some products, it has less than 5 brands. Hence the result will return a b c #N/A #N/A I want to change #N/A to blank instead. Is there any formula I can use to convert #N/A to blank. Currently, I am using =IF(ISNA(B8),"",C8) and it works fine. But ISNA is not recognised in the Xcelsius software I am using. Can anyone help? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Have you tried =IF(ISERROR((D1*E1)),"",(D1*E1)) rather than ISNA Also try this free software its full of easy formulas and saves me hours every day http://www.asap-utilities.com/ It has no spyware or anything that could cause an issue and its FREE !! Best of luck David |
#3
|
|||
|
|||
Hello.
I'm afraid Xcelsius doesn't support the Excel functions ISNA, nor ISERROR, nor ISERR. Any other way to detect a #N/A? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |