# Need help in antilog calculation in excel

#### shashibioinfo143

##### New Member
Dear sir/mam,

i have query regarding antilog value calculation.

i have values of -log10(pvalue) and i want Pvalue

so value of -log10(pvalue) as x

and divide by 10 so it is x/10 and -(x/10)

used POWER function to calculate antilog value POWER(10, -(x/10))

POWER(10, -(17.70776/10)) i got value 0.016952 but when i reverse i.e when i use this value in -log10(pvalue) formula i get 1.77076 value is it correct way to do

need help

Thank you

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### Eric W

##### MrExcel MVP
Welcome to the forum.

Some of your intermediate steps I don't understand. Given a value in A1, and the -LOG10 function in B1, then the formula in C1 is the inverse of B1 and returns A1.

ABC
10.0169521.7707790.016952

</tbody>
Sheet2

Worksheet Formulas
CellFormula
B1=-LOG10(A1)
C1=POWER(10,-B1)

</tbody>

<tbody>
</tbody>

#### shashibioinfo143

##### New Member
i know the value of z in formula Z=-LOG10(x) now i need value of X so i used formula X = POWER(10, -(Z/10)) so i got some value of X but when i used X value again in formula Z =-LOG10(x) im getting one point below for example.

11.29558 =-LOG10(X)

when i used X = POWER(10, -(11.29558/10)) i got value of X as 0.0742

but when i used X value in formula =-LOG10(x) i get value 1.1295960947 point value is shifted.

Need help

Thank you

Welcome to the forum.

Some of your intermediate steps I don't understand. Given a value in A1, and the -LOG10 function in B1, then the formula in C1 is the inverse of B1 and returns A1.

ABC
10.0169521.7707790.016952

<tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
B1=-LOG10(A1)
C1=POWER(10,-B1)

<tbody>
</tbody>

<tbody>
</tbody>

#### Eric W

##### MrExcel MVP
Don't divide by 10. Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,164,427
Messages
5,837,167
Members
430,481
Latest member
nizambakhshi ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back