Need some REALLY easy Excel help

pX

Golden Member
Feb 3, 2000
1,895
0
71
OK, have a lab report due in 30 minutes. Need to finish it fast. Here's what I need to do.

take a whole column and divide every value by .0007235 then take 20log of that. so like if its column B,, 20log(B/.0007235)


I know this is probably really easy, but I can't seem to figure it out,, I've got a case of the 'I don't want to think' brain today....

any help?
 

b0mbrman

Lifer
Jun 1, 2001
29,470
1
81


<< take a whole column and divide every value by .0007235 then take 20log of that. so like if its column B,, 20log(B/.0007235) >>


In block C% where % is a number, write

=20*log(b%/.0007235,10)

Hope that helps ;)