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

K

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

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)
 
K

kyrbi

Do you mean this?
=IF(D100<>0;(IF(L100=K100;"""";IF(L100<K100;"m";"k")));"")

--
Click to expand...
Yes,

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

Thanks
 
B

Bob Phillips

It is 4 quotes not 3.

--

HTH

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

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.
 
P

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)
 
Top