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
Bookmarks