IF formula

nSomnius

New Member
Joined
Nov 7, 2013
Messages
26
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
Joined
Sep 21, 2016
Messages
2,609
Re: Need some help with what I thought was a basic IF formula

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

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,239
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
Joined
Nov 7, 2013
Messages
26
Re: Need some help with what I thought was a basic IF formula

Much obliged everyone! All set now.
 

Forum statistics

Threads
1,077,784
Messages
5,336,329
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top