formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
match formula 2
#N/A help please 2
Adding ISERROR to formula 3
Joining Formulae 2
Set add function ignore #N/A 1
IF Function 6
Correct #N/A Value 6

Back
Top