# IF formula

#### nSomnius

##### New Member
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

##### Well-known Member
Re: Need some help with what I thought was a basic IF formula

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

#### Yongle

##### Well-known Member
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

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

Much obliged everyone! All set now.