Nested formula in IF Function

Hi all!

First of all thank you for providing a solution to my previous post, it was extremely helpful! (and quick).

I have another question. I am trying to build an IF function that does the following:

=IF($AA157=0,"","1/$AA157")

...as you can see I want the cell to display nothing if AA157 displays '0', but if it displays another value, say '5', then I want it to trigger a formula that divides 1/AA157 (in this case, it would be 1/5, which would equal 0.2, or 20%).

I am not sure if this is possible, but I would really appreciate some help.

Thank you!

Shaun

Thanks very much! I completely forgot about the significance of the speech marks