I want (Cell A) Blank unless Cell B reads a certain word.

**Eric_Raine_85** · 08-15-2017, 10:26 PM

Hi There,

Small question for ya, I only want a cell (Cell A) to say "Yes" if (Cell B) says the word Security, Something like IF (Cell A) is Yes then (Cell B) changes to Security.

Thankyou

**alansidman** · 08-15-2017, 10:34 PM

I'm not sure from your thread if A is variable or B is variable. Please clarify as you explanation is confusing. Which cell is dependent on the contents of the other?

**Eric_Raine_85** · 08-15-2017, 11:00 PM

Ok, so Cell A is a drop down box that has 2 choices 'Yes' and 'No', If Cell a says 'No' Then Cell B will stay Blank but if it says 'Yes' then Cell B will say 'Security'.

**Logit** · 08-15-2017, 11:16 PM

.
Paste in B1:

Please Login or Register  to view this content.

**Eric_Raine_85** · 08-15-2017, 11:21 PM

Thats it, Thankyou.

**Logit** · 08-15-2017, 11:23 PM

You are welcome.

I want (Cell A) Blank unless Cell B reads a certain word.

LinkBack

Thread Tools

Rate This Thread

Display

I want (Cell A) Blank unless Cell B reads a certain word.

Re: I want (Cell A) Blank unless Cell B reads a certain word.

Re: I want (Cell A) Blank unless Cell B reads a certain word.

Re: I want (Cell A) Blank unless Cell B reads a certain word.

Re: I want (Cell A) Blank unless Cell B reads a certain word.

Re: I want (Cell A) Blank unless Cell B reads a certain word.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Cell reads £31.96 behind it says £31.956 I need to it just say £31.96

Im trying to add values together if the following cell reads yes

How do I blank a row when it reads 0

need a formula that reads contents of cell up to a blank space

Reads value in cell and prompts a msg box

cell reads as label but returns a value

[SOLVED] Anyone know how to use hex formula that reads a cell? I want to .

Bookmarks

Bookmarks

Posting Permissions