Is there a way to use a caret symbol in field calculator? ^?

[Anonymous User]

Here is the field calculator formula I'm trying to use. It's an Excel formula I've copied over and replaced referenced cells with columns in my table.

100-(15*(((0.445*((0.8*[SUM_t2])^1.15))+ (0.13 * ((0.8*[SUM_t1])^1.35)))^0.5))

[DanPatterson · Accepted solution]

^ in python is **, meaning to the power of, hence **0.5 is the sqrt

[Anonymous User]

That did the trick. Thanks!

[ManishPatel]

Hi Anthony Von Moos,

Not that I have ever come across, but I think what you could do is use either VBScript or Python and translate your Excel formula to python and use that in the field calculator to calculate the values.

Hope this helps.

Cheers,

Manish

If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.