Hi, Can you please help?

I currently have a formula which shows the following;

=IF(F3="Stockland Green","Stockland Green,"" ")

This shows if stockland green is in cell F3 then show stockland green otherwise show false.

However, could I do a formula which shows if Stockland green is NOT in the field show "pioneer place"?

Thanks in advance.

I've managed to work this one out. Answer is;

=IF(F3<>"Stockland Green","Pioneer Place,"" ")

Glad you were able to work it out, but there is a minor problem with your syntax You have the last comma in the wrong place,

your formula outputs: Pioneer Place,"

with a following comma and parentheses markFormula should be:

=IF(F3<>"Stockland Green","Pioneer Place","")

The comma comes after the parentheses mark so the Pioneer Place is enclosed

in parentheses then the comma, then two parentheses to denote a blank entry.MIKE

message edited by mmcconaghy

Or, just to show that an IF statement can work with various syntaxes... =IF(F3="Stockland Green", "", "Pioneer Place")

Also be aware that "" is not the same as " ".

If you use =IF(F3="Stockland Green",

" ", "Pioneer Place") in a cell as a means to show it as empty, it will not be.However, if you use =IF(F3="Stockland Green",

"", "Pioneer Place") instead then Excel will consider the cell to be empty.You can prove this to yourself as follows:

In A1 enter =""

In A2 enter =" "Both cells will look empty.

In B1 enter =A1="" and drag it down to B2.

B1 will display TRUE because A1 is "empty" but B2 will display FALSE because A2 contains a space.

"" is considered a Null String which (more or less) equates to an empty cell.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03

Ask Your Question

Weekly Poll

Do you think facial recognition technology should be regulated?

Discuss in The Lounge

Poll History