if function

[baz0912]

Hi,

I don't know what it is but for some reason my IF formula is not working. It is as follows:

=IF(Input!$B$4=''Sheet 1 BCV'',''LUL Nominee BCV Limited trading as Company BCV Registration in England and Wales Company Number 2342334,''LUL Nominee SSL Limited trading as Company BCV Registration in England and Wales. Company Number 54657'')

Is it because it doesn't understand long bits of text?

Any help would be much appreciated.

Thanks
Harry

[dominicb]

Good morning baz0912

Is it because it doesn't understand long bits of text?

No, there are a couple of things. Firstly you didn't close off your quotes at the end of the first piece of text. Second, you seem to be using the single apostophe twice (on my keyboard, also marked with @, next to ; ). You need to use the double quotes (shifted 2). They might look the same to use, but not to Excel.

=IF(Input!$B$4="Sheet 1 BCV","LUL Nominee BCV Limited trading as Company BCV Registration in England and Wales Company Number 2342334","LUL Nominee SSL Limited trading as Company BCV Registration in England and Wales. Company Number 54657")

HTH

DominicB

[arthurbr]

Hi,

I don't know what it is but for some reason my IF formula is not working. It is as follows:

=IF(Input!$B$4=''Sheet 1 BCV'',''LUL Nominee BCV Limited trading as Company BCV Registration in England and Wales Company Number 2342334,''LUL Nominee SSL Limited trading as Company BCV Registration in England and Wales. Company Number 54657'')

Is it because it doesn't understand long bits of text?

Any help would be much appreciated.

Thanks
Harry

Which error do you get?
A double quote seems to be missing after 2342334..

[arthurbr]

Good morning baz0912


No, there are a couple of things. Firstly you didn't close off your quotes at the end of the first piece of text. Second, you seem to be using the single apostophe twice (on my keyboard, also marked with @, next to ; ). You need to use the double quotes (shifted 2). They might look the same to use, but not to Excel.

=IF(Input!$B$4="Sheet 1 BCV","LUL Nominee BCV Limited trading as Company BCV Registration in England and Wales Company Number 2342334","LUL Nominee SSL Limited trading as Company BCV Registration in England and Wales. Company Number 54657")

HTH

DominicB

Hi Dominic,
how can you see the differnce between double quotes and two apostrophes?

[dominicb]

Hi arthurbr

how can you see the differnce between double quotes and two apostrophes?

I can't!
I copied the OP's formula to a spreadsheet, spotted the missing double quotes, added them, and the formula still error'd when it shouldn't. When you arrow through the entire formula one character at a time, you just might spot it.

I didn't at first, but it's a very simple formula and there was clearly nothing wrong with it...

DominicB

[baz0912]

Hi Dominic,

Thanks very much for your help!

Harry

[arthurbr]

Hi arthurbr

I can't!
I copied the OP's formula to a spreadsheet, spotted the missing double quotes, added them, and the formula still error'd when it shouldn't. When you arrow through the entire formula one character at a time, you just might spot it.

I didn't at first, but it's a very simple formula and there was clearly nothing wrong with it...

DominicB

Ok Thx for this useful tip