Formula Help

[littleone]

Hi,
Hope someone can help. I'm trying to create a formula for the following:-

e.g.if cell F6 is 0.5 or less then value is cell C6 divided by 2, if cell F6 is more than 0.5 then value is 0.

Just can't seem to get it right!!!

Thanks in advance

 

[Weaver]

=if(F6>0.5,0,C6/2)

 

[VoG]

Try

=IF(F6<=0.5,C6/2,0)

 

[superkopite]

=IF(F6<0.5,(C6/2),0)

But what do you do if F6 if equal to 0.5

 

[Weaver]

or maybe

=C6*(F6<=0.5)/2