Thread: IF?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shapper shapper is offline
external usenet poster
 
Posts: 22
Default IF?

Hello,

I have the following:

=10 + INDEX(B$47:K$52;MATCH($E3;B$47:B$52;0);3)

I get #N/A when there is not match.

How can I change it to have 10?

Thanks,
Miguel