Solved If Statements Not In My List

October 8, 2018 at 01:38:13
Specs: Windows 7
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.


See More: If Statements Not In My List

Reply ↓  Report •

#1
October 8, 2018 at 01:50:02
I've managed to work this one out.

Answer is;

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


Reply ↓  Report •

#2
October 8, 2018 at 06:47:33
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 mark

Formula 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

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#3
October 8, 2018 at 10:00:32
✔ Best Answer
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


Reply ↓  Report •
Related Solutions


Ask Question