Hi guys, I'm doing an assessment for Uni which involves using Excel to calculate various acoustic measurements of a certain room. Not sure if anyone here knows any acoustics, but I have a formula to find every Mode in the room:

f(nx, ny, nz) = (c/2)*SQRT((nx/Lx)^2+(ny/Ly)^2+(nz/Lz)^2)

Basically the formula relies on the dimensions of the room (Lx, Ly, Lz) and integer multiples of them (nx, ny, nz). So I have a very long list of different combinations or nx, ny, nz:

0, 0, 1
0, 1, 0
1, 0, 0
0, 1, 1
......
6, 7, 5 etc...

These three values are entered in separate columns.

When there are two cells containing "0"s, I would like a cell to display the text "Axial"
When only one cell contains "0" I would like the text to read "Tangential"
When all three cells contain a number other than "0" it should show "Oblique"

So FINALLY my question is, how can I make a cell show one of these words depending on what the 3 cells containing the numbers are showing....?

Hope that makes some sense... I'm getting so confused!

Thanks greatly in advance!

Henry