Multiplying a cell in an IF Function

[sjm44]

Hello,

I am trying to complete an IF function based on the following.

Cell B2 has a value of 3388 and Cell C2 has a value of 990.

I need to work out..

If B2 is greater than C2*2, yes and if not, no.

This is what it I am using at the moment...

=IF(B2>C2*2,"yes","no")

Everything is coming out as Yes, it doesn't look like it is multiplying C2 by 2.

Any help is much appreciated.

 

[Lewiy]

Nearly there, but need some extra brackets
=IF(B2>(C2*2),"yes","no")

Also, if you are happy with TRUE/FALSE rather than yes/no, then you could just use:
=B2>(C2*2)

 

[sjm44]

Nearly there, but need some extra brackets
=IF(B2>(C2*2),"yes","no")

Also, if you are happy with TRUE/FALSE rather than yes/no, then you could just use:
=B2>(C2*2)

Sorted, thanks a lot.