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

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")));"")

Replace the 4 in your formula with a pair of quotes so that you have a total of 4 quotes (ie instead of "4" use """")

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" <[email protected]> wrote in message
news:Kz%[email protected]...
> 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")));"")
>
>

> 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

It is 4 quotes not 3.

--

HTH

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


"kyrbi" <[email protected]> wrote in message
news:[email protected]...
> > 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
>
>

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.

kyrbi wrote:
> > 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

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

--

Regards,

Peo Sjoblom

<[email protected]> wrote in message
news:[email protected]...
> 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.
>
> kyrbi wrote:
> > > 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
>

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

6

--

HTH

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


"kyrbi" <[email protected]> wrote in message
news:[email protected]...
> Thanks
> using 4 quotes is the trick..... strange, how do you put 2 quotes?
>
>