Need Help With IF Functions with Greator Than and Less than signs

[nbeb1215]

Im having trouble writing a If statement. The problem is to write a statement that determines whether the infant is greater or less in weight than the overall average, and assign a 1 to those greater and a 0 to those less.
Ive tried a few things but i am struggling to get it to cooperate

 

[6StringJazzer]

No idea where you want the result to go, but if column A is the infant weights then you want this starting in row 2 then copy down.

=IF(A2<$D$4,0,1)

This will assign a 1 to weight greater than or equal to the average.

 

[Peter_SSs]

This would also do the same thing as @6StringJazzer's formula

=--(A2>=D$4)

 

[zero269]

=--(A2>=D$4)

Hi Peter,

I've never see this (--) before... that I can recall. Is there an official name for this?

I found some calling it a:

• double negative
• double minus sign
• double dash, etc.

but no one sited the source to it's meaning.

One site offered a simple description which makes perfect since with your use case:

However, I'm curious as to the official name...

Thanks

 

[6StringJazzer]

There is not an "official" name, it's just a unary minus followed by another unary minus. I suppose people might make up pet names for it, but there is nothing official.

The inner (second) unary minus forces the Boolean expression to be converted to a number, but TRUE would be converted to -1. The outer (first) unary minus switches it back to positive.

 

[Alex Blakenburg]

I know it as a double unary.
See if this helps at all:

Double unary

A unary operation is an operation with only one operand (input).

exceljet.net

Any arithmetic operation applied to True/False will work eg
+0 or *1 will do the same thing. It just seems to be common practice to use "--"