google sheets – IF and IFS do not work properly

I'm trying to locate the data present in different sheets. I tried to use IF and IFS.
You will find below the formulas that I have used. For IF, I receive NOT IN USE even when I know that there should be some leaves and I get NA for IFS except 2 cells which gives a correct answer.
What am I doing wrong or is there another way to do it?


=IF(B2=Casula!$A:$A,"Casula",IF(B2=Miranda!$A:$A,"Miranda",IF(B2=Parramatta!$A:$A,"Parra",IF(B2=Leichhardt!$A:$A,"Leich","NOT IN USE"))))

You need a shared cpanel hosting able to work properly with phpmyadmin

Well … not really throwing a key in this thread … but it looks like you use a lot of database. There may be better ways to interact with the database rather than via phpMyAdmin.

I do not know if phpMyAdmin is really written to be fast. It is more written to present an easy-to-use interface for non-technical users.

Maybe I'm wrong … but I do not think I know too many people who use phpMyAdmin heavily to manage a database. They can use phpMyAdmin to make changes to a database in a blue moon. They can also interface directly with the database with a custom PHP script or with a local or remote database client.

The Python program does not work properly

I want to say first that I am beginner and this is part of my first program:

def square_area (side):
back (side * side)

def rectangle_area (length, width):
back (length * width)

def circle_area (radius):
back (3.14 * radius * radius)

shape = input ("What shape surface do you want to calculate:")

if form! = "square" or "rectangle" or "circle":
print ("Only circle, rectangle and square .. Sorry !!")

if shape == "square":   
    side = int(input("Enter side: "))
    result = (square_area(side))

elif shape == "rectangle":
    length = int(input("Enter length: "))
    breadth = int(input("Enter breadth: "))
    result = (rectangle_area(length, breadth))

elif shape == "circle":
    radius = int(input("Enter radius: "))
    result = (circle_area(radius))

Even after typing circle or square it displays only first message ("Only circle square....")


MS Teams: The request is not properly formatted. The & # 39; login_hint & # 39; is duplicated

I get this error while trying to connect to MS Teams and I'm not sure what that means.

enter the description of the image here

Does anyone know what causes it?

Amazon Web Services – React Router DOM Does Not Work Properly on Amplify AWS Console

I have deployed the reaction application on the Amplify console after their documentation. The site is deployed and working well, I can navigate using links, but when I try to land directly on a URL, I am redirected to my configured page 404.

Below is the code I'm using


And here's what my career looks like –

     } />

Here is the link to the application –

How to properly sell VIP subscriptions on your website | Promotion Forum

Selling access to hidden content or exclusive sections of your website is a great way to reward members for donations, paid subscriptions, or the occasional sale of a VIP subscription. However, this exclusive access should be worthwhile for your users if you hope to make money in the long run and not leave a bad taste in the mouth of your loyal and paying members. Today, we will examine some common flaws in VIP subscription plans and focus on how to create a positive and rewarding experience for your users.

Types of exclusive access

There are many ways to reward paying subscribers. For example, many YouTube channels have chosen not to use paid internal subscriptions to the video network and have instead implemented faithful follow-ups on Patreon. This external network allows content creators (not only YouTube) to offer quality content to their subscribers at varying prices. There are often different packages that offer varying benefits. Maybe a small fee of $ 1 / month will be …

cpanel – How to configure email so that it works properly with the punycode domain?

I have a punycoded domain with cpanel linux hosting. The domain is correctly coded for visits to the site. However, the e-mail address is punycode display. Example:

"" should be posted as "contacto@casamazunte├▒"

An idea on how to do it?

boot – Ubuntu 18.04 does not start properly

I face a problem, every time I start my computer, it displays a distorted display and hangs only there. The distorted display is shown below. The distorted display on the screen

I have to turn it off with the power button and when I turn it on again, it will display the messages below and then start up properly. Message at second start

I can not find why I am getting this problem.

linux – The addition of guest VirtualBox does not work properly

I've installed Gentoo on a virtual machine and
addition of guest too.

I've checked that it works. For example, I can drag and drop a file from the host to the virtual machine and vice versa. I also have a shared clipboard. But the resolution of the screen has not changed. I would like to put at least 1920×1080, help me solve this problem ;-]

Here is the output of xrandr:

user@localhost ~ $ xrandr
xrandr: Failed to get size of gamma for output default
Screen 0: minimum 640 x 480, current 1024 x 768, maximum 1024 x 768
default connected 1024x768+0+0 0mm x 0mm
   1024x768       0.00* 
   800x600        0.00  
   640x480        0.00

Advanced Custom Fields – The ACF plug-in explains how to properly escape $ _GET variables before forwarding them in a query

I found this code in the Advanced Custom Fields documentation and everything works. What worries me, is a comment in the original message saying that the code was open to SQL injection because it does not correctly escape $ _GET variables before to transfer them in a query. I was wondering how to do this effectively so that the code continues to run but remains safe or if another method is recommended.
I've tried using $ wpdb but it broke the function.


I do not know the subject well, so any explanation on how to secure it would be very useful. The original code is below:

 function my_pre_get_posts( $query ) {

    // bail early if is in admin
    if( is_admin() ) return;

    // bail early if not main query
    // - allows custom code / plugins to continue working
    if( !$query->is_main_query() ) return;

    // get meta query
    $meta_query = $query->get('meta_query');

    // loop over filters
    foreach( $GLOBALS('my_query_filters') as $key => $name ) {

        // continue if not found in url
        if( empty($_GET( $name )) ) {



        // get the value for this filter
        // eg:,sydney

        $value = explode(',', $_GET( $name ));

        $meta_query = ();
        // append meta query
        $meta_query() = array(
            'key'       => $name,
            'value'     => $value,
            'compare'   => 'IN',


    // update meta query
    $query->set('meta_query', $meta_query);