Re: #N/A problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Kl,

This completely solved my problem and I appreciate your help.

I can see I got myself into a mess about "TRUE" v TRUE and have untangled it
(all the related cells now are consistently TRUE (rather than "TRUE"). I've
learned a bonus new fact.

One query - the formula I used
=IF(ISERROR(Data!S9),"Apples",IF(Data!S9,Data!R8,"Apples")) ....
on the last part it is ... IF(Data!S9,Data!R8,"Apples")). My question is
why the comma between Data!S9 and Data!R8? Does the comma mean the same as
equals?

If you don't have the time to reply, I'll understand. I'm just hungry for
understanding.

sincerely

Jeff


"KL" <NOSPAMlapink2000@xxxxxxxxxxxxxxxxx> wrote in message
news:OFxZG$bgFHA.2424@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Jeff,
>
> Try something like this:
>
> =IF(ISNA(Data!S9),"Apples",IF(Data!S9="TRUE",Data!R8,"Apples"))
>
> or
>
> =IF(ISERROR(Data!S9),"Apples",IF(Data!S9="TRUE",Data!R8,"Apples"))
>
> if your "TRUE" is in reality the logical value TRUE, then try one of
> these:
>
> =IF(ISNA(Data!S9),"Apples",IF(Data!S9,Data!R8,"Apples"))
>
> or
>
> =IF(ISERROR(Data!S9),"Apples",IF(Data!S9,Data!R8,"Apples"))
>
> Regards,
> KL
>
>
> "Jeff" <anon@xxxxxxxxx> wrote in message
> news:daf6jf$pa6$1@xxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> The formula below works well. However, sometimes the result is a "#N/A"
>> due to incorrectly entering the data (a typo). It is a lookup formula
>> and causes a break in the macro. I'd like to incorporate something that
>> if a "#N/A" happens it is just the same as FALSE and results in "apples".
>>
>> The formula is:
>>
>> =IF(Data!S9="TRUE",Data!R8,"Apples")
>>
>> I have read the Excel help and tried to resolve this but alas no
>> resolution.
>>
>> Any help would be greatly appreciated.
>>
>> regards
>>
>> Jeff
>>
>>
>>
>
>


.

Relevant Pages

  • Re: Interactive Query to Reference user Defined Variables
    ... Hi Jeff, Thank you for taking the time to look at this. ... The Range A4:AX5 is the Criteria where row 4 contains the field names to ... Best Regards, ... Tim ...
    (microsoft.public.access.queries)
  • RE: Chinese Character
    ... Windows 98 SE and Big 5 Code ... Regards ... >What Windows Version and which database u're using? ... >> Jeff Li ...
    (microsoft.public.win2000.general)
  • Re: Please Help - Losing Internet connection
    ... Regards, ... Jeff ... > He hasn't got ISA, so no need for checking the LAT. ...
    (microsoft.public.windows.server.sbs)
  • Re: Hello From New Orleans !!!!!
    ... Glad to hear it Jeff. ... my gear made it back on Tuesday. ... Regards, ... That is Great news. ...
    (rec.arts.movies.production.sound)
  • Re: Combo box locked?
    ... Sorry Jeff, coming back to my problem again. ... Sam ... All combo boxes? ... >> Regards, ...
    (microsoft.public.access.forms)