# 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.

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### 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.

1,089,557
Messages
5,408,931
Members
403,243
Latest member
psabin8951