How to show "yes" or "No" in a cell if certain criteria is met?

[Bojan]

Hi,
I'm doing a report with monthly averages for each team. What I want is when
an average number is met at A2,... A3, ... to show "yes" or "no" something
like this:
A2 A3
123 yes
95 no
150 yes

 

[Roger Govier]

Hi

=IF(A2>=AVERAGE($A$2:$A$100),"yes","no")
Copy down as required

 

[ShaneDevenshire]

Hi,

If you already have the average calculated in the spreadsheet, say in cell
A50, then you formula could be:
=IF(A2>A$50,"Yes","No")

 

[Bojan]

Thank you guys that worked for me.

Cheers

Hi

=IF(A2>=AVERAGE($A$2:$A$100),"yes","no")
Copy down as required