IF formula

[nSomnius]

This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing?

=IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100")))

Happy to share the spreadsheet if it helps, it's nothing personal.
Here's how it shows up in Excel:

https://www.dropbox.com/s/kgdl1dhj3z1bgfu/excel problem.jpg?dl=0

The one cell that can't change as I use the fill handle is AX7. As soon as I drag the formula down a column all I see is the formula in the resulting cells. Ideas?
Thanks for any help with this.

 

[footoo]

Re: Need some help with what I thought was a basic IF formula

=if(az2<$ax$7,"",ba2/az2*100)

 

[Yongle]

Re: Need some help with what I thought was a basic IF formula

quote marks are the cause of your problem
=IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100")))

=IF((AZ2<$AX$7),(""),((BA2/AZ2)*100))

removing brackets not required too..
=IF(AZ2<$AX$7,"",BA2/AZ2*100)

 

[nSomnius]

Re: Need some help with what I thought was a basic IF formula

Much obliged everyone! All set now.