How to log transform your dataset in Excel

[@INTANURSURIABINTIWAHABIUPM]

Hello.. I have a question. What if your data have negative values? How can you run a log model if your data have some negative values? Thank you

[@nihadashraf1072]

Did u resolve it?

[@AkshayKumar-vd5wn]

You cannot. Only positive values, numbers, items can be transformed.

[@gregorysikakwe4159]

When I tried to log transform in excel I have issues faith typing the log on a cell . No dropdown appears for me to choose. When I type LN nothing appears and I get stuck there. How can I over come this problem. I need your guide. Thanks.

[@highlarious30]

=ln( )

[@olufunmilolablossom2348]

Thanks❤

[@ayenewendalew3150]

Not visible