How can I get A1l to = yes/no if a value other than N/A is added to either B1 or B2

**NinjaBear** · 02-27-2012, 05:28 AM

Hi

I am trying to get A1 to show "no" unless a value other than N/A is added to either B1 or B2, then A1 shall show "yes"

any ideas please?

thanks

**Marcol** · 02-27-2012, 05:56 AM

If you mean that N/A is a returned error (#N/A) then

Please Login or Register  to view this content.

If N/A is a string (abbr for "Not Available") then

Please Login or Register  to view this content.

**NinjaBear** · 02-27-2012, 06:22 AM

Hi

Yes sorry "N/A" is just a value ive entered (not applicable)

So i tried to use the 2nd formula you kindly provided but it doesn't seem to work as the value stays the same (yes or no)when entries added to either B1 or B2.

Just to confirm what im trying to achieve:

B1 & B2 currently show "N/A" and A1 shows "No", however if the user enters a value in either B1 or B2 then A1 will show "Yes"

hope that makes sense

thanks for your time

**Marcol** · 02-27-2012, 07:11 AM

Change the OR() statement to AND()

Please Login or Register  to view this content.

Is that what you need?

**NinjaBear** · 02-27-2012, 07:25 AM

sorry it still doesn't work - the value remains the same

any ideas?

thanks

**NinjaBear** · 02-27-2012, 07:45 AM

sorry it does work i didn't type it in right DOH!

thanks very much

**Pepe Le Mokko** · 02-27-2012, 07:48 AM

FWIW the formulae on the forum are enclosed between code tags so you can copy them easily

**Marcol** · 02-27-2012, 07:49 AM

Happy to have helped.

How can I get A1l to = yes/no if a value other than N/A is added to either B1 or B2

LinkBack

Thread Tools

Rate This Thread

Display

How can I get A1l to = yes/no if a value other than N/A is added to either B1 or B2

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Re: How can I get A1l to = yes/no if a value other than N/A is added to either B1 or

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions