Formula Help

[anniemalec]

Hi there

Please can somebody help me with the syntax for a formula requesting the following:

=if(c4,"£117.60"=>,"1","0")

Not quite sure to put the => or if this is even possible? Tried a few variations and coming back dudd.

Basically need the formula to input a 1 if the value of C4 is greater than £117.60 and a 0 is below.

Any help is appreciated, Thanks.

 

[njimack]

=if(c4>=117.6,1,0)

 

[VoG]

Try

=IF(C4>=117.60,1,0)

 

[mole999]

=if(c4>117.6,1,0)

for greater than 117.6

 

[anniemalec]

Perfect, thank you both very much