Excel 2007 : entering IF arguments in another cell for reference

[Bobcat1]

Hello,

This is my first time posting on this board, I wanted to see if anyone could clue me in on a way I can put an IF argument in a cell and then have another formula reference that cell to find out what the argument is.

Essentially i want to create a search button or cell that will list items under or over a certain value but I want the user to be able to define weather it wants items '> x' or '< x'.

So the ideal set up would be that the user plugs in > 300 (lets call this cell A2) and then a formula (in A3) goes as follows = IF(A1 A2, do something, do something else).

Any help would be appreciated, i'm also open to other suggestions on how to do this. I recently got transferred to my current job and although I know excel, my previous job didn't require it so i'm kinds rusty with it.

[Fotis1991]

Hi and welcome to the forum.

Something like this, maybe?

=IF(A2>300,1,IF(A2>300,2,IF(A2=300,3)

[TMS]

@Fotis: should one of those ">" be a "<"?


Regards, TMS

[Fotis1991]

Off course my friend

Thank you!

=IF(A2>300,1,IF(A2<300,2,IF(A2=300,3)