excel IF statement

Hobbsie · 28 Jun 2016 at 13:43

Hi all, im trying to do what i think is basic but cant seem to get it to blooming work.

So i want to make an IF statement that if E2 is blank then put N/A if it is not blank do nothing.

So i have =IF(E2="","N/A","")

From what i remember that's saying if e2=blank, then add N/A, else leave blank?

Or am i barking well up the wrong tree here.

Hobbsie · 28 Jun 2016 at 13:51

weird i get 0 ? im not sure can you put a formula and its outcome in the same cell?
because it works if i do =IF(E3="","NA","") because thats the cell below

Hobbsie · 28 Jun 2016 at 15:25

Can i ask can i put this formula in the cell that im trying to display n/a?

Basically i am importing a .csv file with shipping addresses.
Some customers have filled out line 2 on shipping some haven't.
Now royal mail need to see something inside shipping column 2 being E.
So i was hoping to put an IF statement in the whole of column E with the above code, but i guess because the IF statement is about the E column it will bring an error because i guess you can have a IF statement in its own cell/column?

Hope that makes any kind of sense if not ill have to look at a company to make me a program or something.

Hobbsie · 28 Jun 2016 at 15:32

I get the following error.

Careful, we found one or more circular referances in your workbook that might cause your formulas to calculate incorrectly.
FYI: a circular referance can be a formula that refers to its own cell value, or refers to a cell dependent on its own cell value.

That's why im thinking i cant put an if statement in the cell/column i want changing?

Hobbsie · 28 Jun 2016 at 15:33

Or what i can do is use B2 to hold the IF statement but to look at E column and change E not B?

Hobbsie · 28 Jun 2016 at 15:48

yes sorry the formula lives in the cell which i was trying to explain but im bad at explaining things. thanks ill give that ago. thanks all

Hobbsie · 28 Jun 2016 at 15:56

Can i have a different cell house the formula? IE cell A2-10 will actully change cell E2-10?

Hobbsie · 28 Jun 2016 at 22:06

Thanks for all your help, just another question if i may!
Is there an easy way of changing text from in a cell.
What im after is if a cell says united kingdom to change it to GB and if a cell says france to change it to FR for example?
Is there any easy ways in doing this or do i need to go into coding?

Thanks