Solved: Simple formula not working

[Neodubois]

I have the following straightforward formula =IF($R21="";"";Y$11)

if in R21 there is something it should copy the formula which is in Y11 to the though it doesn't work no idea why...

[feathers212]

Use commas, not semi-colons when writing formulas:

=IF($R21="","",Y$11)

[Neodubois]

tried that Excel doesn't accept , can't differenciate the logical test from te rest

[feathers212]

I don't have any problems when I put that formula into a cell. Are you looking to have the value from Y11, or the actual formula from Y11?

[Neodubois]

I need the actual formula from Y11

[feathers212]

It seems to me that the value and the formula would be the same thing. Or does the formula in Y11 change? I guess I need a better idea of what you are trying to accomplish.

[Neodubois]

Ok, in Line 11 I have my formulas

as of line 15 I have a table which needs to be updated the formula ias the same in the whole column but should only be "pasted" there if there is a value in column Q which is the first column and is updated manually

The formula in line 11 works fine if I copy it myself

[mdmackillop]

You can create a named formula and use that name in the If function.
=IF(D9="","",adds)

[peacenik]

You can create a named formula and use that name in the If function.
=IF(D9="","",adds)

Wow, that is something I never new about. I am not sure when I will use it but it is cool.

[Neodubois]

Seems like a good idea

Does this "name" apply to only one sheet or can I than use the same for all sheets?

[mdmackillop]

You can use it in any sheet, but the values will come from the "original" sheet, not the active one. I don't know if the sheets can be Relative as well as the cells.

[Neodubois]

If I copy the sheet in which I defined the names won't that create a duplicate problem? though the formulas will be in the same place

[mdmackillop]

Personally, I would create a simple workbook and test the results, That way I would be sure of what's going on.

[Neodubois]

This works indeed with everything except for this particular file

It is probably due to the BLP aka Bloomberg formulas, have had a lot of problems with those