Formulas - converting dBdsx to Volts peak to peak

[alex148]

I would like to enter the following formulas in excel:
First, converting dBdsx to Volts peak to peak the formula is:
Vpp = (6)10^(dBdsx/20).
These are the steps used with a scientific calculator:
A- Obtain the result of taking the dBdsx value and dividing it by 20
B- Take this result and store it in the calculator's memory.
C- Obtain a result by entering 10 then pressing the x^y function key followed by memory recall.
D- take this result and multiply it by 6
E- the result will be the dBdsx value converted to Vpp.

Second, converting Volts peak to peak dBdsx the formula is:
dBdsx = 20log10(Vpp/6).
These are the steps used with a scientific calculator:
A- Take the Vpp valus and divide it by 6.
B- Press LOG function key on the calculator.
C- Take the result and multiply it by 20.
D- This will be the Vpp value converted to dBdsx.

I think I figured out the Vpp to dBdsx as "=LOG(A16/6)*20" (not sure) but I can't figure out the first formula.

Any advice would be appreciated
Alex

[NBVC]

=6*10^(A1/20) where A1 contains your dBdsx value

and

=20*LOG(A2/6) where A2 contains your Vpp value


Note: You can name the cells, A1 and A2, dBdsx and Vpp, respectively so that you can use those names in the formula...

To name a cell, select it and type the name in the box left of the formula bar at top of the sheet.

[alex148]

Thank you for the quick response.
Alex