putting a quote in a cel as a result of a formula

[kyrbi]

Hi is it possible to replace the nr 4 with a " in this formula?

I just want to put a " in the cel

Thanks!

=IF(D100<>0;(IF(L100=K100;"4";IF(L100<K100;"m";"k")));"")

 

[Bob Phillips]

Do you mean this?

=IF(D100<>0;(IF(L100=K100;"""";IF(L100<K100;"m";"k")));"")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[kyrbi]

Do you mean this?

=IF(D100<>0;(IF(L100=K100;"""";IF(L100<K100;"m";"k")));"")

--

Yes,

I mean this, but this is not working, the formula gives an error......
because of the 3 quotes......

Thanks

 

[Bob Phillips]

It is 4 quotes not 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[mdicostanzo]

Try this and see if it's what you want:

=IF(D104<>0,IF(L104=K104,CHAR(147),IF(L104<K104,"m","k")),"")

Also, you are using semi-colons in your IF statement when you should be
using commas.

 

[Peo Sjoblom]

Of course anyone that has semicolons as delimiter in the regional settings
would have to use that (all of continental Europe
for instance)

 

[kyrbi]

Thanks
using 4 quotes is the trick..... strange, how do you put 2 quotes?

 

[Bob Phillips]

6

--

HTH

RP
(remove nothere from the email address if mailing direct)