Calculate decibels at range

[Celtillos]

Hi, Mr. Excel
For a project I'm working on, I need to be able to calculate how far a sound of a particular volume will travel. What I need is for it to return the result of subtracting 6 for every doubling of distance. I've tried several ways with the help of a retired technician, and we are both stumped.
So, if I enter 100, the result should be 94 at the cell representing 2 meters, 88 at the cell presenting 4 meters, 82 at the cell repsenting 8 meters, and so on up to the point where the decreasing number reaches zero.
Thanx in advance.

 

[dreid1011]

Are you looking for something like this?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	1	2	4	8	16	32	64	128	256	512	1024	2048	4096	8192	16384	32768	65536	131072	262144	524288	1048576	2097152	4194304
2	100	94	88	82	76	70	64	58	52	46	40	34	28	22	16	10	4	0	0	0	0	0	0
Sheet2

Cell Formulas
Range	Formula
B1:W1	B1	=A$1*2
B2:W2	B2	=MAX(A$2-6,0)

If not, please provide some sample data with expected results.

 

[Celtillos]

This is EXACTLY what I need. I can't express my gratitude enough.

 

[dreid1011]

You're welcome, and happy to help.

 

[Micron]

Interesting. I thought, there's no way that the distances are arranged like that because that would be too easy. I figured that if you started with a number (e.g. 1) they would be like

and you would need to retrieve rows (or columns, doesn't matter) 1,2,4,8 and so on. I couldn't figure how to do that so I gave up.

 

[dreid1011]

Interesting. I thought, there's no way that the distances are arranged like that because that would be too easy. I figured that if you started with a number (e.g. 1) they would be like
View attachment 109604
and you would need to retrieve rows (or columns, doesn't matter) 1,2,4,8 and so on. I couldn't figure how to do that so I gave up.

Lucky guess I suppose. I did think about your approach too, but wanted to start simple and if that wasn't it, go bigger.