What does this formula means =B$6<>""

[mdfahiem]

Hi Gurus,


What does the below formula does or means?


=B$6<>""


Thanks in advance.


Regards,
Fahim

 

[FDibbins]

It is testing to see if B6 is (not) empty or contains "nothing"

 

[mdfahiem]

It is testing to see if B6 is (not) empty or contains "nothing"

Hi Ford,

Thanks a lot for your quick reply.


I have a series of cells for which this formula is applied. Along with this formula, I also want to apply the data validation (list) to this series. If anything else is entered apart from the list, it should throw a message "Please enter valid code".

How can I have these 2 validation for same cell (or series of cells)?

Thanks in advance.

Regards,
Fahim

 

[MarkRCC]

Data Validation (List) will already give the user an error if they attempt to enter a value that is not on the designated list.

How are you trying to use the =B$6<>"" formula? You could set up a If X="TRUE" then Y sort of check for the result of the initial formula.

EDIT: If that were to be how you would use the initial check, you would need to change the formula to =IF(B$6<>"", "TRUE", "FALSE") or whatever other true/false responses you want to work with.

 

[mdfahiem]

Data Validation (List) will already give the user an error if they attempt to enter a value that is not on the designated list.

How are you trying to use the =B$6<>"" formula? You could set up a If X="TRUE" then Y sort of check for the result of the initial formula.

EDIT: If that were to be how you would use the initial check, you would need to change the formula to =IF(B$6<>"", "TRUE", "FALSE") or whatever other true/false responses you want to work with.

For my requirement to be fulfilled, I simply replaced the formula (=B$6<>"") with the list (for selection), and it is working very well.

Initially I was planning to use 2 data validations, but it is working well with 1 data validation.

Thanks for your kind suggestions and guidance.

Regards,
Fahim