Need help in antilog calculation in excel

shashibioinfo143

New Member
Joined
Jan 3, 2017
Messages
2
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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,617
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

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2

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

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

shashibioinfo143

New Member
Joined
Jan 3, 2017
Messages
2
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,316
Members
414,053
Latest member
Dual Showman

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top