This returns a false or a true statement

This returns a false or true : =IF(Y9="","",(AI/Y9)<$AB$6,''")
How do I correct this to return a Zero(0) if the answer smaller that the AB6. And a true not a number when it is large than.


I have tried several things and it just doesn't do what I have asked.


Thanks

GFV

An IF() function takes 3 parameters - The Logical test, Return value if True, Return value if False

You have 4 parameters so I doubt you can enter that fomula in a cell.

Try
=IF(Y9="","",IF(AI/Y9<$AB$6,0,''")

Originally Posted by Special-K

=if(y9="","",if(ai/y9<$ab$6,0,''"))

Thanks for the correction.

Thanks for your help on this I will try it.
I think I have done that and came up with an error. So my original formula was:

IF(Y9="","",(AI9/Y9) and this returned a Number which is good thing. But I wanted to add a filter to that formula so that it would return a Zero(0) or another number that would be greater than the Absolute Number Value in a certain cell i.e. AB6 ($AB$6) . does that make since. So if the Value of AB6 was 10 and the (AI9/Y9)=9 I would get a 0. And if the value was 10 I would get an 10 and so on.

Does that help?

GFV