Sound calculations

[jag808]

Hi,

I am quite new to excel and would really like to see if i can achieve some time saving calculations.

I am attempting to work with sound calculations and the following outcomes.

I have two sound sources (2 cells)

If the difference between them if 0 then i want to add and additional 3dB

If the difference between them if 1 then i want to add and additional 2,5dB (to the highest number)

If the difference between them if 2 then i want to add and additional 2,0dB (to the highest number)

If the difference between them if 3 then i want to add and additional 1,5dB (to the highest number)

If the difference between them if 4 then i want to add and additional 1,0dB (to the highest number)

This goes on until a difference of 15 ++, and then i want to retain the highest number!

Can anyone give me any pointers on this?

Regards

John G

[Andrew-R]

Well returning the larger of two cells (say A1 and A2) is just the function =MAX(A1,A2)

Adding the decibels should be straightforward as well, although I'm not sure I understand your logic. Continuing the sequence you've listed suggests that if the difference is 5 then you add 0.5dB to the higher value and if the difference is 6 then you add 0, and it's unclear what you do after that.

If you simply want to add 1 to the higher value for any difference of 4 or more then try...

=MAX(A1,A2)+LOOKUP(ROUND(ABS(A1-A2),0),{0,1,2,3,4},{3,2.5,2,1.5,1})

[nadarajan]

Hi jag ,
Welcome to the Forum.You just prepare a table (say in column F & G) i.e difference in coloumn F and
value to be added in column G. If you are having the values (two sound sources) in a1 and b1, use this
formula in c1 =MAX(A1:B1)+VLOOKUP(ABS(A1-B1),F:G,2,0)
try it and cheers.