Average letters

S

superkopite

hiya guys,

I need some help. in my worksheet cells B1 to B13 contain either an "r
or a "g" i need cell b14 to display an "g" if 75% of the cells B1:B1
contain a "g" if not it should display an "R".

I am a noob and have no idea how to do this but have to get it done fo
work 2moro!!!

Cheers

Jame
 
B

bpeltzer

Countif can tell you how many cells in a range meet a certain condition. So
you could do something like
=if(countif(b1:b13,"g")>=3*countif(b1:b13,"r"),"g","r")
 
Top