IF Function: Use of Logical Operators Located in a Cell

[CMDMA03]

Is it possible to outline your logical expressions (e.g., >=, <=, etc...) in a cell and then reference that cell in an IF function?

Example:
I have a percentage score in B5 (e.g., 10%), and a target score that contains logical operators in B4 (e.g., >=9.8%). I'd like to be able reference the two cells in an IF function and produce a binary result, but I get #NAME or #VALUE errors when I've tried the syntax below. I've searched and can't seem to find much on this anywhere. Maybe I'm not searching with the right language. Does anyone have suggestions? Thanks in advance.

=IF(B5&$B$4,0,1)

=IF(B5$B$4,0,1)

=IF(B5AND($B$4),0,1)

 

[Scott Huish]

In that case, no need for an added function call:

=-(COUNTIF(B5,B4)-1)

 

[Rick Rothstein]

In that case, no need for an added function call:

=-(COUNTIF(B5,B4)-1)

Multiplying the -1 though the parentheses...

=1-COUNTIF(B5,B4)

 

[Scott Huish]

That's better!