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